Wait number of seconds in A1
 

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

Wait number of seconds in A1
 

Try this:
Application.Wait Now() + Range("A1").Value
"CLR" wrote in message
...
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

Wait number of seconds in A1
 

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



"CLR" wrote in message
...
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

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

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

Wait number of seconds in A1
 

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