timed macro execution

N

Neil

Hi All,

Any ideas on how to (efficiently) create a 'timer' in a macro which will
step through its execution
with set timing between loops ??

Thanks.
 
B

Bob Phillips

Neil,

Take a look at the Wait method in VBA help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
T

Tushar Mehta

In addition to Bob's suggestion, you might also want to check the
Application object's OnTime method.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top