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
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
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.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I found some stuff from Pearson Software. Works perfectly.
tnx Pearsons if your watching.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks