clock

[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

 

[Peo Sjoblom]

Alun,

Chip Pearson has some code at his site

http://www.cpearson.com/excel/ontime.htm

 

[Ecco]

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