Setting timer to run macro at regular intervals
 

Use the OnTime method.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP

On Sun, 11 Jan 2009 01:07:40 +0800, "sun" wrote:

Dear Excel Gurus,

Can I set a timer to run a macro at regular time intervals? Is there a
convenient API to use?

Thank you very much in advance.