Forum Discussion
Kyle_P19
Jul 16, 2020Copper Contributor
Record Time of Entry
Is there a way to record the time of data entries in a cell? So, I would like the cells in column A to record the time, as I enter data in the cells of column B. It seems possible, I just haven’t ...
JMB17
Jul 16, 2020Bronze Contributor
One other option. You could right click on the worksheet tab and select view code. Then paste this code into the code window.
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Cells(1).Column = 2 Then
Application.EnableEvents = False
Target.Columns(1).Offset(0, -1).Value = Now
Application.EnableEvents = True
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Cells(1).Column = 2 Then
Application.EnableEvents = False
Target.Columns(1).Offset(0, -1).Value = Now
Application.EnableEvents = True
End If
End Sub