Timer

  • Thread starter Thread starter R Winkler
  • Start date Start date
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top