VBA Code to wait 50-150 mS
 

Looking for a few lines of code that will slow down a text animation in 12
steps. A loop counting to say 1000 might be expedient, but this would
depend on PC performance. So far, I have found methods of waiting whole
numbers of seconds, but nothing less than a second.

VBA Code to wait 50-150 mS
 

http://www.mentalis.org/apilist/Sleep.shtml

Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds _
As Long)

The Sleep function suspends the execution of the current thread for a
specified interval.

For half a second.

Sleep 500

Paul

----------------------------------------------------------------------------------------------------

Looking for a few lines of code that will slow down a text animation in 12
steps. A loop counting to say 1000 might be expedient, but this would
depend on PC performance. So far, I have found methods of waiting whole
numbers of seconds, but nothing less than a second.

VBA Code to wait 50-150 mS
 

many thanks for the suggestion and the link - both useful


wrote in message
...
http://www.mentalis.org/apilist/Sleep.shtml

Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds _
As Long)

The Sleep function suspends the execution of the current thread for a
specified interval.

For half a second.

Sleep 500

Paul

--------------------------------------------------------------------------
--------------------------

Looking for a few lines of code that will slow down a text animation in
12
steps. A loop counting to say 1000 might be expedient, but this would
depend on PC performance. So far, I have found methods of waiting whole
numbers of seconds, but nothing less than a second.