Method to pause VBA?

T

tkstock

Is there a way to pause a VBA app for about 10 seconds?
Application.Wait doesn't work for some reason. I'm using Office 2002.
I can't find in the online help any other function that would do this.
Is it possible that Application.Wait is referring to something I don'
have installed?

Thanks
 
T

Tom Ogilvy

application.Wait should work. If you are getting an error, perhaps check in
tools=>References and see if you have a reference marked as MISSING. If so,
you need to uncheck it.

Another approach would be to use application.Ontime and two subs.

See Chip Pearson's page for information on using application.OnTime

http://www.cpearson.com/excel/ontime.htm
 

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

Can the Application.wait method create a pause less than a second? 2
VBA equivalent for WScript.Sleep 3
Pause a macro by resetting current time 3
pause vba action without using Application.Wait? 2
How to Pause an Excel VBA script without freezing excel 1
pause macro execution 2
How to pause without being "modal" 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Top