Running a Sub Procedure every 5 seconds
 

Is it possible to program this?

Alan Beban

Running a Sub Procedure every 5 seconds
 

Alan,

Use Application.OnTime. See www.cpearson.com/Excel/OnTime.aspx for details
and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Alan Beban" wrote in message
...
Is it possible to program this?

Alan Beban

Running a Sub Procedure every 5 seconds
 

Chip Pearson wrote:
Alan,

Use Application.OnTime. See www.cpearson.com/Excel/OnTime.aspx for
details and example code.


Perfect! Thank you. The online help I saw didn't deal with repeating and
I decided not to try to reinvent the wheel.

Thanks again,
Alan