Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Time Function
Hello All,
I want to run a procedure every x minutes. To test this, I am using the following: Application.OnTime EarliestTime:=Now + TimeValue("00:00:10"), procedu="SeeifTimeisPass" Then I have a sub: Sub SeeifTimeisPass msgbox "Hi" end sub It runs through one time, but then does not reschedule to run again (running every 10 seconds in this example). Any ideas why. Thanks,. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Time Function
OnTime only runs the code once. You have to reschedule the OnTime
method each time. See www.cpearson.com/excel/ontime.htm for example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bill" wrote in message ink.net... Hello All, I want to run a procedure every x minutes. To test this, I am using the following: Application.OnTime EarliestTime:=Now + TimeValue("00:00:10"), procedu="SeeifTimeisPass" Then I have a sub: Sub SeeifTimeisPass msgbox "Hi" end sub It runs through one time, but then does not reschedule to run again (running every 10 seconds in this example). Any ideas why. Thanks,. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an XLS function to convert std time to Military time? | Excel Worksheet Functions | |||
Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Function Call Specified at Run Time rather than Compile Time? | Excel Programming | |||
Function to convert Time String to Time | Excel Worksheet Functions |