Macro Wait command
 

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

--
Donki
-----------------------------------------------------------------------
Donkin's Profile: http://www.excelforum.com/member.php...fo&userid=2371
View this thread: http://www.excelforum.com/showthread.php?threadid=37599

Macro Wait command
 

Works perfectly

Thank

--
Donki
-----------------------------------------------------------------------
Donkin's Profile: http://www.excelforum.com/member.php...fo&userid=2371
View this thread: http://www.excelforum.com/showthread.php?threadid=37599

Macro Wait command
 

Another option that I find easier to read:

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



fastmonkey512 wrote:

This worked for me

Application.Wait TimeSerial(Hour(Now()), Minute(Now()), Second(Now()) +
10)

This will pause the code for 10 seconds

Hope this helps

--
fastmonkey512
------------------------------------------------------------------------
fastmonkey512's Profile: http://www.excelforum.com/member.php...o&userid=23982
View this thread: http://www.excelforum.com/showthread...hreadid=375992

--

Dave Peterson