LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Wait number of seconds in A1


Thanks for the comeback Walter, but the other way works just fine, once I
got it straightened out........do you see some hidden danger with this
method?

Vaya con Dios,
Chuck, CABGx3


"Walter Briscoe" wrote in message
...
In message of Sun, 5 Jul 2009
21:59:41 in microsoft.public.excel.programming, Howard31
writes
Try this:
Application.Wait Now() + Range("A1").Value
"CLR" wrote in message news:OeLJGJb$JHA.1248
...
Hi All......
If someone would be so kind.......how can this code be modified to
"wait" the number of seconds corresponding to the value in A1?

Application.Wait Now() + 0.000005787037


I would not do it that way. YMMV.

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
...
Sleep Range("A1").Value*1000 ' Untested
--
Walter Briscoe



 
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
Wait with TimeValue using the seconds from a worksheet cell Tom Joseph Excel Programming 7 March 3rd 09 08:29 PM
wait msgbox for 3 seconds only Eddy Stan Excel Programming 2 November 26th 08 06:58 PM
Wait Seconds and Tenths Chip Pearson Excel Programming 7 December 26th 06 02:12 PM
Wait Seconds and Tenths Zone Excel Programming 0 December 23rd 06 04:46 PM
Display MsgBox wait for 10 seconds then click on yes automatically Vikram Dhemare Excel Programming 7 October 29th 06 11:57 AM


All times are GMT +1. The time now is 08:11 PM.

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"