Guys ,
I used this simple code to track the changes made in worksheet( sheet7) using timestamp. The code only works if i change the cell value within sheet 7. However i have a data entry form on sheet6 which data goes to sheet 7. If i make any changes from sheet6 , timestamp does not happen. There are no issues of data changes between sheet 6 and sheet 7. What am I doing wrong here?
I used this simple code to track the changes made in worksheet( sheet7) using timestamp. The code only works if i change the cell value within sheet 7. However i have a data entry form on sheet6 which data goes to sheet 7. If i make any changes from sheet6 , timestamp does not happen. There are no issues of data changes between sheet 6 and sheet 7. What am I doing wrong here?
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myTableRange As Range
Dim myDateTimeRange As Range
Dim myUpdatedRange As Range
Set myTableRange = Sheet7.Range("A4:r9999")
If Intersect(Target, myTableRange) Is Nothing Then Exit Sub
Application.EnableEvents = False
Set myDateTimeRange = Range("v" & Target.Row)
Set myUpdatedRange = Range("w" & Target.Row)
If myDateTimeRange.Value = "" Then
myDateTimeRange.Value = Now
End If
myUpdatedRange.Value = Now
Application.EnableEvents = True
End Sub
Last edited by a moderator: