Time intervals below 1 second.

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

Hi folks, help please with Excel2000

I would like to repeat a macro at say half second
intervals. Using "Application.Wait (Now + TimeValue
("00.00.01"))" seems to limit me to one second. Whats the
solution please?

TIA. derek
 
Use the system's high-resolution timer.

The full code with class can be found in John Green's "Excel 2000 VBA", page
336.

Cheers,
FK
 
I would maintain my own form of time ticks. So each interval represented,
say, a 100th of a second.
Special functions would be needed to convert this back to excel/vba time.

Windows API provides some of this functionality for you, in the form of
SYSTEMTIME type:
http://groups.google.co.nz/groups?h...TF-8&selm=01bd0f6f$755604c0$920246a6@kurtfish

Interestingly, this other article shows an example of sub-second resolution.
=NOW() in A1, format A1 as "hh:mm:ss.00"
http://groups.google.co.nz/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]
 
Back
Top