VBA Code to wait 50-150 mS

[Hotbird]

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.

 

[pfsardella]

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

 

[Hotbird]

many thanks for the suggestion and the link - both useful