Wait number of seconds in A1

  • Thread starter Thread starter CLR
  • Start date Start date
C

CLR

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

TIA
Vaya con Dios,
Chuck, CABGx3
 
Hi All..........

Never mind.......I always get smarter as soon as I post a question....

Application.Wait Now() + Range("a1").Value / 86400

Vaya con Dios,
Chuck, CABGx3
 
In message <[email protected]> of Sun, 5 Jul 2009
21:59:41 in microsoft.public.excel.programming, Howard31
Try this:
Application.Wait Now() + Range("A1").Value
Click to expand...

I would not do it that way. YMMV.

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
....
Sleep Range("A1").Value*1000 ' Untested
 
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
 
In message <[email protected]> of Mon, 6 Jul 2009
11:21:26 in microsoft.public.excel.programming, CLR
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?
Click to expand...

Not at all! It just makes more sense to me to have code which waits for
two seconds rather that for two seconds from now. (I now they're the
same thing.) As I said, YMMV.
 
Back
Top