timed macro execution

  • Thread starter Thread starter Neil
  • Start date Start date
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.
 
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)
 
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
 
Back
Top