MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pusing a macro


Posted by Joe C on July 16, 2001 8:12 AM

Does anyone have a simple way of creating a time loop, so a macro would wait 5 seconds before continuing?


Posted by Damon Ostrander on July 16, 2001 9:03 AM

Joe,

You don't need a loop. Excel 97 and beyond have an application object Wait method that lets you pause for any desired amount of time. Just check the Wait Method in the VBA helps--there is a pretty good example there.

Happy computing.

Damon

Posted by Joe C on July 17, 2001 5:52 AM

Worked like a charm. Many thanks.