'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

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
.

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
.

Rocky,

Use the Sleep API call for smaller time interval. It takes as its argument
the number of milleseconds.

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub Test()
Sleep dwMilliseconds:=100&
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


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

Thanks Chip that works great! Where can I find out more about API calls so
I can utilize more of their powers.

--
Regards,
Rocky McKinley


"Chip Pearson" wrote in message
...
Rocky,

Use the Sleep API call for smaller time interval. It takes as its argument
the number of milleseconds.

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub Test()
Sleep dwMilliseconds:=100&
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


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

Rocky,

You can read the API reference at

http://msdn.microsoft.com/library/de...start_page.asp

Examples in VB for many APIs can be found at
http://www.mentalis.org/index2.shtml


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com




"Rocky McKinley" wrote in message
...
Thanks Chip that works great! Where can I find out more about API calls
so
I can utilize more of their powers.

--
Regards,
Rocky McKinley


"Chip Pearson" wrote in message
...
Rocky,

Use the Sleep API call for smaller time interval. It takes as its
argument
the number of milleseconds.

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub Test()
Sleep dwMilliseconds:=100&
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


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