#Solved by Petr Radiměřský & Biplab Das
Can anyone tell me how to fixed the date when i enter the value? when i opened the excel sheet everyday then date has been changed automatically. but I would like to fixed the date when i put the value in d3.
Ataul Hasan Ranju In comment section of the link download file:-
https://m.facebook.com/groups/393224307706029/permalink/914581282236993/?mibextid=Nif5oz
Ataul Hasan Ranju Can try also
is date will be changed if i open this file day after tomorrow.
Ataul Hasan Ranju In my way it will not changed
Ataul Hasan Ranju Check & Share Feedback
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns(4)) Is Nothing Then Exit Sub Application.EnableEvents = False Cells(Target.Row, 1).Value = Date Application.EnableEvents = True End Sub
Petr Radiměřský Thanx it works. could you please tell me how can i put this in OneDrive excel sheet?
Ataul Hasan Ranju If you mean a file opened via a web browser, then it is not possible. If you mean only saved on OneDrive and opened through a normal Excel application, then you can.
Petr Radiměřský Thanxxx a lot
Petr Radiměřský can i write this (Target, Columns(4),(5),(6),(7)) when data insert into multiple column?
Ataul Hasan Ranju you need Event handler for this.
Please follow the steps.
• Right mouse click on sheet bar > select 'View Code' • Cop paste the below code in VBA editor
Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Sheets("Sheet5").Range("D:D")) Is Nothing Then Target.Offset(, -3).Copy Target.Offset(, -3).PasteSpecial xlPasteValues Application.CutCopyMode = False End If End Sub
• Done. Now once you put anythisng in Column D, then Column A date will fixed
*Remember to save the workbook/excelfile as XLSM format
Text korun jodi kono question thake
Ataul Hasan Ranju See the date in cell A3, once I put 1250 on D3, VBA fixed the date in A3