View Single Post
  #5   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