How to make a macro run every fifth minute
 

Hi

I would like one of my macros to update every fifth minute. I.e. I have a
box with an attached macro and I want this macro to be run every fifth minute
automatically. Can anyone help me with this. I would appreciate it

Andreas

How to make a macro run every fifth minute
 

You can use the OnTime method. See www.cpearson.com/Excel/OnTime.aspx .


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Andreas Ingo" wrote in message
...
Hi

I would like one of my macros to update every fifth minute. I.e. I have a
box with an attached macro and I want this macro to be run every fifth
minute
automatically. Can anyone help me with this. I would appreciate it

Andreas