Timer

Posted by Charles Deen on November 23, 1999 1:39 PM

I need the computer clock or to build my on timer that
calculates automatically without pressing F9. I need
for it to be a 24 hour timer.

Posted by Chris on November 24, 1999 7:47 AM

Charles,

You set up an On Time procedure to do a worksheet.calculate on the intervals you require. See the online help for more info on On Time procedures.

Chris

Posted by Charles Deen on November 26, 1999 4:41 AM

Thanks for the help, Could you show me an example.

example 11-25-99 - 11-20-99 = 5
The 11-20-99 to be a constant date and the 11-25-99
to be todays date. What I need to happen is when
the computer clocks rolls over at midnight for the 5
change to a 6 automatically without pressing F9.