Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wait with TimeValue using the seconds from a worksheet cell | Excel Programming | |||
wait msgbox for 3 seconds only | Excel Programming | |||
Wait Seconds and Tenths | Excel Programming | |||
Wait Seconds and Tenths | Excel Programming | |||
Display MsgBox wait for 10 seconds then click on yes automatically | Excel Programming |