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.
