Related:
- Cell input to call macro in adjacent cell
- How to input @ in laptop - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Input phone lock code sos - Phones, PDA & GPS Forum
1 response
Hi Chris,
Implement this code on the worksheet you want it to work on (right click on the worksheet tab, click on view code):
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveCell.Offset(-1, 1) = Time
End Sub
Whenever you put something in a cell and hit ENTER, the current system time is being put in the adjacent cell to the right.
NOTE that you have to confirm your entry by hitting ENTER and not use the arrows or TAB.
Best regards,
Trowa
Implement this code on the worksheet you want it to work on (right click on the worksheet tab, click on view code):
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveCell.Offset(-1, 1) = Time
End Sub
Whenever you put something in a cell and hit ENTER, the current system time is being put in the adjacent cell to the right.
NOTE that you have to confirm your entry by hitting ENTER and not use the arrows or TAB.
Best regards,
Trowa
