Method to pause VBA?
 

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

--
tkstoc
-----------------------------------------------------------------------
tkstock's Profile: http://www.excelforum.com/member.php...fo&userid=1444
View this thread: http://www.excelforum.com/showthread.php?threadid=26468

Method to pause VBA?
 

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

--
Regards,
Tom Ogilvy

"tkstock" wrote in message
...

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't
have installed?

Thanks!


--
tkstock
------------------------------------------------------------------------
tkstock's Profile:
http://www.excelforum.com/member.php...o&userid=14443
View this thread: http://www.excelforum.com/showthread...hreadid=264681