Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to insert a row at regular intervals of row dsnema Excel Programming 1 March 7th 08 11:57 PM
Inserting a Row Range at regular intervals [email protected] Excel Programming 1 April 3rd 07 05:58 PM
How to trigger a macro at regular intervals? ÉH Excel Programming 3 January 6th 06 09:10 PM
Setting x axis scale to time with variable intervals webbuzzard Charts and Charting in Excel 1 June 27th 05 07:13 PM
Timer which counting smaller than 1 second intervals Berend Botje[_37_] Excel Programming 6 November 19th 04 09:19 PM


All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"