In message of Mon, 6 Jul 2009
11:21:26 in microsoft.public.excel.programming, CLR
writes

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?

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.


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



--
Walter Briscoe