Ontime procedures

[ironmouse]

I am currently recalculating my application every "00:00:01" (1 second)
Using the Ontime Procedure. How can I increase this to quarter
seconds. My Ontime function doesnt seem to allow sub 1 second updates.
Any ideas??? Tnxs

 

[keepITcool]

see:
http://www.cpearson.com/excel/ontime.htm

concentrate on the WindowsTimers (APIs)
note they work a bit different that OnTime.
Procedures scheduled with Ontime need to reschedule themselves

With SetTimer you set it once, and it will run every x milliseconds
and keep running until Killed.

Just make sure you kill it before closing the workbook or quitting
excel. Also be sure to include some form of errorhandling.
else you're in for some crashes...


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ironmouse wrote :

 

[Leith Ross]

Hello IronMouse,

The OnTime procedure only counts in seconds. To get sub seconds (like
milliseconds) you would have to use the API SetTimer function. This is
more complicated than using OnTime. You can use Google to find plenty
of examples and decide for yourself if this is an avenue you would like
to take.

 

[ironmouse]

I found some stuff from Pearson Software. Works perfectly.
tnx Pearsons if your watching.