Macro wait 30 seconds then Complete the Macro

  • Thread starter Thread starter Vick
  • Start date Start date
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?
 
hi
one way.
Application.Wait(Now + TimeValue("0:00:15"))

this will pause the macro 15 seconds.

regards
FSt1
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Excell 2000 macro will not open file! 1
Macro not finishing due to loading workbook 7
How to run a macro automatically when the file is opened? 1
Wait statement in macro 1
First 2023 ? From the frozen wastes of Wisconsin nowadays, but originally from the sophisticated part of Yorkshire....(Chuckle). 4
macros 1
Expanding ranges in macros 4

Back
Top