Hello Cruzesr,
Yes you can by using a macro that is triggered by a cell's contents changing. Follow the directions below.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Value <> "" And Target.Column = 1 Then
Target.Offset(0, 1).Value = Format(Now(), "hh:mm:ss")
End If
Application.EnableEvents = True
End Sub()
Installing the Worksheet_Change() Event Macro
1. Copy the Macro code above using CTRL+C
2. Open Excel and Right Click the Sheet Tab the macro will run on
3. Click on View Code in the pop up menu
4. PressCTRL+V to Paste the macro code
5. Press CTRL+S to Save the macro code in the workbook
6. Close the VBE and return to excel using ALT+Q
Sincerely,
Leith Ross
Bookmarks