Timer function

[Jan Kronsell]

Hi NG!

I know I can use the OnTime function to make something happen at a given
time, or in a certain timeinterval, but is there anyway I can make something
happen in recurring intervals, like once every minute as long as the
spreadsheet is open - and still be able to use the sheet.

Jan

 

[Chip Pearson]

Jan,

You can use OnTime to do this. See www.cpearson.com/excel/ontime.htm for
example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[pfsardella]

Watch the linewrap. Place in the WorkBook_Open event,

Const dblOneMinute As Double = 0.00069444444444
Dim intA as Integer

For intA = 0 To 1200
Application.OnTime Now + (intA * dblOneMinute),
"YourProcedure"
Next intA

HTH
Paul

 

[Jan Kronsell]

Thanks! Got it working now

Jan