Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing code execution
Hello All,
I would like to pause code execution for approx five secs before running the next set of statements. Is this the correct code to do that??? ****some code here**** Application.Wait (Now + TimeValue("0:00:05")) ****some code here**** Thanks, Rohit |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing code execution
Rohit,
You could try this: Application.Wait Now + TimeSerial(0, 0, 5) John Rohit Thomas wrote: Hello All, I would like to pause code execution for approx five secs before running the next set of statements. Is this the correct code to do that??? ****some code here**** Application.Wait (Now + TimeValue("0:00:05")) ****some code here**** Thanks, Rohit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted code execution | Excel Discussion (Misc queries) | |||
Code Execution Message | Excel Discussion (Misc queries) | |||
code execution has been interrupted | Excel Discussion (Misc queries) | |||
code execution has been interrupted | Excel Discussion (Misc queries) |