Thread: Current Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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