View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default 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.