Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel OnTime
The following code runs my proceedure very well;
RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds) Application.OnTime earliesttime:=RunWhen, procedu=cRunWhat, Schedule:=True BUT Sometimes I need to stop the timer before it runs the proceedure so I put the following code in another Sub snd run it when I need to. Application.OnTime earliesttime:=RunWhen, procedu=cRunWhat, Schedule:=False But for some reason it is not stopping the OnTime. What am I missing please ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel OnTime
DOH !
It does work, I was reading the wrong variable when checking it !! Thanks for reading anyway. "MAS" wrote in message ... The following code runs my proceedure very well; RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds) Application.OnTime earliesttime:=RunWhen, procedu=cRunWhat, Schedule:=True BUT Sometimes I need to stop the timer before it runs the proceedure so I put the following code in another Sub snd run it when I need to. Application.OnTime earliesttime:=RunWhen, procedu=cRunWhat, Schedule:=False But for some reason it is not stopping the OnTime. What am I missing please ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
OnTime bug? | Excel Discussion (Misc queries) | |||
OnTime VB | Excel Discussion (Misc queries) | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming |