timed macro execution

[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.

 

[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)

 

[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