Timer

R

R Winkler

Want to use excel to record real time. Be able to record
running intervials and keep track of the number of
intervals. Interuptions would be via enter key or space
bar. Any suggestions?
 
E

Earl Kiosterud

R,

Sub Initialize()
Application.OnKey " ", "PostTime"
End Sub

Sub PostTime()
Range("A65533").End(xlUp).Offset(1, 0) = Now
End Sub

Format column a for date/time as needed.
 
Top