Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sendkeys(keys,wait) how do I use wait MM Excel Discussion (Misc queries) 1 February 11th 09 03:47 PM
Should I Wait? Chaplain Doug Excel Discussion (Misc queries) 0 February 6th 07 04:58 PM
wait Eddie[_4_] Excel Programming 3 November 15th 03 03:37 PM
Excel code to Wait until Word finishes printing before closing Mike Molyneaux[_2_] Excel Programming 2 October 24th 03 02:45 AM
Problem with WAIT Mike[_46_] Excel Programming 0 August 31st 03 01:27 AM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"