Forum Discussion
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 ...
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