time stamping

[sunroyal]

Is there a way to have a macro button enter the current time? I woul
like to to run on the toolbar or when you type in a certain cell

 

[Harald Staff]

Sure:

Sub Datestamp()
Sheets(2).Cells(2, 3).Value = TimeValue(Now)
End Sub

 

[Don Guillett]

If you want automatic
right click on sheet tab>view code>copy/paste this>SAVE.
Now when you make a change in a10 a11 will reflect the current time

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$10" Then [a11] = Time
End Sub