Macro wait 30 seconds then Complete the Macro

V

Vick

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?
 
F

FSt1

hi
one way.
Application.Wait(Now + TimeValue("0:00:15"))

this will pause the macro 15 seconds.

regards
FSt1
 
H

Harald Staff

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
 
Top