Autofill date if a change happens on the row

[Raky]

Hello,

I am new to excel and I used a code I found on this forum to autofill the date of day depending if any change happened on the row (I was not able to find again the thread).

I used this VBA code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Row < 3 Then Exit Sub
If Target.Column < 3 Then Exit Sub
Cells(Target.Row, "B") = Date
End Sub


This works perfecly for what I intend to do but when I use it, it is not possible anymore to do ctrl+Z. That is a problem for me so I would like to find a solution but I am not sure that there is any (I use excel 2021). Is it possible to have the result and keep the "going back" fonctionnality ?

 

[My Aswer Is This]

Hello,

I am new to excel and I used a code I found on this forum to autofill the date of day depending if any change happened on the row (I was not able to find again the thread).

I used this VBA code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Row < 3 Then Exit Sub
If Target.Column < 3 Then Exit Sub
Cells(Target.Row, "B") = Date
End Sub


This works perfecly for what I intend to do but when I use it, it is not possible anymore to do ctrl+Z. That is a problem for me so I would like to find a solution but I am not sure that there is any (I use excel 2021). Is it possible to have the result and keep the "going back" fonctionnality ?

Hello,

I am new to excel and I used a code I found on this forum to autofill the date of day depending if any change happened on the row (I was not able to find again the thread).

I used this VBA code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Row < 3 Then Exit Sub
If Target.Column < 3 Then Exit Sub
Cells(Target.Row, "B") = Date
End Sub


This works perfecly for what I intend to do but when I use it, it is not possible anymore to do ctrl+Z. That is a problem for me so I would like to find a solution but I am not sure that there is any (I use excel 2021). Is it possible to have the result and keep the "going back" fonctionnality ?

Using Ctrl+Z will not undo what a script does.