Timestamp

[arnoldmiranda]

Hi,
When I use a data validation on an excel sheet, it it possible for me capture an automatic timestamp the moment I select something from the dropdown on any cell


Thanks

 

[VoG]

Which cells contain the DV and where should the timestamp go? Should a timestamp overwrite an existing timestamp?

 

[arnoldmiranda]

Hi,
From column D onwards to infinity. The timestamp should can go either before or after the text selected from the datavalidations, the dateastamp once captured should not change


Thanks

 

[VoG]

Maybe this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column >= 4 Then
    Application.EnableEvents = False
    If Target.Offset(, 1).Value = "" Then Target.Offset(, 1).Value = Now
    Application.EnableEvents = True
End If
End Sub