Macro Wait command

D

Donkin

Has anyone used a wait command within a Macro, I am looking to pause
Macro for a short time so the user can note some figures from th
spreadsheet. This must be done at a set number of iterations so usin
the breakon the keyboard couldn't be used.

Anything along the lines of wait, count 10seconds, resume would b
ideal.

Any help would be appreciate
 
D

Dave Peterson

Another option that I find easier to read:

Application.Wait Now + TimeSerial(0, 0, 10)
 

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

Top