MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pausing macro

Posted by Richie Turner on September 11, 2001 2:55 AM

How can I get my macro to pause execution for say, 3 seconds? I am moving a graphic across the screen but it going way too fast.

any help would be appreciated


Posted by Chris on September 11, 2001 2:58 AM

Insert this line of code where you want the macro to pause:

Application.Wait Now + TimeValue("00:00:03")

This should do the job!