View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rocky McKinley Rocky McKinley is offline
external usenet poster
 
Posts: 102
Default Minimum time per interval

Hi Patrick,

Have you any example code of how to get Excel to use .001 seconds in Vb such
as using the "Application.Wait" method.

Thanks,
Rocky McKinley


"Patrickl Molloy" wrote in message
...
one millisecond ie .001 of a second

-----Original Message-----
'The below sample line represents 2 minutes interval
Public Const cRunIntervalSeconds = 120 ' two

minutes

I'm just curious what's the "minimum" interval that VBA
can accept?
0.1 sec?
0.01 sec?
0.001 sec?
0.0001 sec?
0.00001 sec or something else?

TIA
Edmund Seet
.