Current Time

[ub]

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

 

[Mike]

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value <> "" Then
Range("A2").Value = Time
End If
End Sub

 

[dlw]

=IF(A1>0,NOW(),0)
that will put the current time if a value of >0 is entered
it will be a funny number, if you format the cell Time it will be a time

 

[ub]

Hi
Please advise, if the time will be saved.
Because NOW(), gives thecurrent time.
Example, If I had entered data in cell A1 yeterday and today when I go in
the sheet. Will I see the time in cell a2 that of yesterday or the current
time.

 

[ub]

I dont want a different time , when I tab to another cell or reopen the sheet.
Is there any way I can store the value of now() in any cell.

 

[ub]

Thanks a lot, It works
Please advise if I can use to automaticaly enter time in my sheet.
Example, if user has entered a value in cell a1, the current time should
stamp autmatically in cell a2 and the time value should be saved.

Thanks

 

[David Biddulph]

That would need VBA. You'll see suggestions in the archives of this
newsgroup.