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?

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?

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?