Current Time

U

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
 
M

Mike

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

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
 
D

David Biddulph

.... but next time you open the sheet, NOW() will be a different time. Did
the OP want that?
 
U

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.
 
U

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.
 
U

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
 
D

David Biddulph

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