New to the Forum and new to VBA
I've created a log book for daily activity and have it set up to put a timestamp (Date column C and Time column D) when ever an event is entered into Column B. It works great, but I'd like it to remain the same date and time even if someone does something like a spell check or make a few changes in the Event Column.
Is this possible?
This is the code I have:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Application.EnableEvents = False
Cells(Target.Row, 3).Value = Date
Application.EnableEvents = True
End If
If Target.Column = 2 Then
Application.EnableEvents = False
Cells(Target.Row, 4).Value = Time
Application.EnableEvents = True
End If
End Sub
Thanks
Dave
Bookmarks