Permanent Timestamp for first entry then remain that timestamp even with edits. A Log file

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

Maybe I'm oversimplifying, but if the date and time stamps are mean to be static, then wouldn't you be able to add a condition in your sheet that says something like below, so you only add the stamp to a cell that doesn't already have one?

Please Login or Register  to view this content.

That works! Very simple but that's all I need.

Thanks!