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 :


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:)