Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro wait 30 seconds then Complete the Macro
Is there a way that once a macro is started, stop at a point and wait 15
seconds before it runs through the rest of the macro? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro wait 30 seconds then Complete the Macro
hi
one way. Application.Wait(Now + TimeValue("0:00:15")) this will pause the macro 15 seconds. regards FSt1 "Vick" wrote: Is there a way that once a macro is started, stop at a point and wait 15 seconds before it runs through the rest of the macro? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro wait 30 seconds then Complete the Macro
It depends on what you want to happen in the meantime, or what to allow, or
why. There are "wait" functions that almost freezes the computer while waiting. I'd prefer to split the procedure in two and call the second one with the Application.Wait command (see Help on this). But if you expect user interaction or want to wait for some other procedure to finish, see if there's another way to do it. HTH. Best wishes Harald "Vick" wrote in message ... Is there a way that once a macro is started, stop at a point and wait 15 seconds before it runs through the rest of the macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wait function in Excel 2000 Macro | Excel Discussion (Misc queries) | |||
MACRO ACTIVATED EVERY 5 SECONDS | Excel Discussion (Misc queries) | |||
Please I need some help to complete a VBA Macro | Excel Discussion (Misc queries) | |||
Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
How do I get an excel macro to stop at a cell & wait for imput? | Excel Discussion (Misc queries) |