Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |