View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Walter Briscoe Walter Briscoe is offline
external usenet poster
 
Posts: 279
Default Wait number of seconds in A1

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