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