Forum Discussion
Conditional formatting when using VBA
Goodday, I used following code to automatically generate a timestamp in a given cell: "Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Handler If Target.Column = 1 And Tar...
Change the line
Target.Offset(0, 1) = Format(Date, "dd/mm/yyyy")
to
Target.Offset(0, 1) = Date
Apply the desired date format to column B (you have to do that only once)