Time stamp for record entry only but not record change

[2vao]

Hi all,

What I have below stamps the date+time for new entry or change of value.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Application.EnableEvents = False
Cells(Target.Row, 8).Value = Date + Time
Application.EnableEvents = True
End If
End Sub

What do I need to change to make it stamp new entries only but not changes ?

Many thanks,
"The more I learn, the more I realize how little I know"

 

[fhqwgads]

can you have it check if the cell where the timestamp goes is blank?
something like

If cellwheretimestampgoes = "" Then

[your code here]

Else

End If

that way if the cell is not blank then it skips to the Else and does nothing

sorry if that doesnt work i'm still a novice at VBA

 

[2vao]

Thanks so much for responding , yes it works very well. Thank you for sharing