Current Time
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value < "" Then
Range("A2").Value = Time
End If
End Sub
"ub" wrote:
Hi
What I want to do is that if I enter a value in a cell (Ex A1), in cell A2,
I want the current system time to automatically stamp and save it.
Please advise if this is possible.
Thanks
|