clock

  • Thread starter Thread starter Alun Davies
  • Start date Start date
A

Alun Davies

Is there a working clock that I can have on an excel
worksheet? I need to input data on the hour every hour
from a running total. This would make it easier if I can
calculate against a clock. I have no problem with the
calculation. Can I switch a macro "on" once every hour??

Alun Davies
 
Here is an example, which runs every hour.

Sub RunEveryHour()
Application.OnTime Now + TimeValue("00:01:00"), "RunMe"
End Sub
Sub RunMe()
Range("a1") = Now() 'or what you want this macro to do
RunEveryHour
End Sub

When you start the macro RunEveryHour, it places current
time in cell A1 in every hour.

Ecco
 
Back
Top