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




"Derek" wrote in message
...
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

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?hl...6a6%40kurtfish

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...s.chatlink.com



"Derek" wrote in message
...
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