Hi there,
I've seen it mentioned, but not implemented that a timer in excel could be set off the system clock? Is there a way to do this so that a VBA program running off the timer would run at a consistent speed on different machines?
Thanks
Hi there,
I've seen it mentioned, but not implemented that a timer in excel could be set off the system clock? Is there a way to do this so that a VBA program running off the timer would run at a consistent speed on different machines?
Thanks
The Application.OnTime method schedules procedures based on the system clock.
Entia non sunt multiplicanda sine necessitate
That schedules procedures to run based on the clock. I'm looking for a timer that counts in real time based on the clock. So that an equation using the cell with the timer will run in real time?
There is no way to do that in VBA alone (you can do anything in Windows API) other than with OnTime.
vba start button (Stamps start time), vba stop button (Stamps end time), the system clock is the timer, simple, then deduct finish from start = time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks