MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pausing in a Macro

Posted by Mike Ronald on September 29, 2001 5:01 AM

How do I get a macro to pause or wait a set amount of time before continuing? Any ideas greatly apprectiated.

Posted by David on September 29, 2001 6:35 AM

You will need to edit the macro in Visual Basic Editor. Determine the point where you would like to pause and at the next line insert the following

Application.Wait(Now + TimeValue("0:00:10))

Macro continues .... after 10sec.

In VB Editor Help, search for WAIT METHOD and click on example for more info.