Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What can we use as an equivalent to "Sleep()" in vb?
I searched through the archives and there were a few messages
discussing this but no actual syntax could be found (at least during 2 searches). Is there any vb equivalent to "Sleep()"? Thanks. :oD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What can we use as an equivalent to "Sleep()" in vb?
Use the Sleep API:
Private Declare Sub Sleep Lib "Kernel32" (ByVal dwMilliseconds As Long) Sub TestingSleep() Sleep 2000 Cells(1) = 1 End Sub RBS "StargateFan" wrote in message ... I searched through the archives and there were a few messages discussing this but no actual syntax could be found (at least during 2 searches). Is there any vb equivalent to "Sleep()"? Thanks. :oD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What can we use as an equivalent to "Sleep()" in vb?
Do you mean this?
Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long) Sub test() Msgbox "Wait for 1 sec" Sleep 1000 Msgbox "Done" End Sub StargateFan wrote: I searched through the archives and there were a few messages discussing this but no actual syntax could be found (at least during 2 searches). Is there any vb equivalent to "Sleep()"? Thanks. :oD |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What can we use as an equivalent to "Sleep()" in vb?
Two ways
Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub WaitSeconds() Sleep 1000 * 3 ' 3 seconds End Sub and Sub WaitFor() Application.Wait Now + TimeSerial(0, 0, 3) ' 3 seconds End Sub -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "StargateFan" wrote in message ... I searched through the archives and there were a few messages discussing this but no actual syntax could be found (at least during 2 searches). Is there any vb equivalent to "Sleep()"? Thanks. :oD |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
What can we use as an equivalent to "Sleep()" in vb?
"Bob Phillips" wrote in message ... Two ways Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub WaitSeconds() Sleep 1000 * 3 ' 3 seconds End Sub and Sub WaitFor() Application.Wait Now + TimeSerial(0, 0, 3) ' 3 seconds End Sub Thanks to everyone for their responses! :oD -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "StargateFan" wrote in message ... I searched through the archives and there were a few messages discussing this but no actual syntax could be found (at least during 2 searches). Is there any vb equivalent to "Sleep()"? Thanks. :oD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard" | Excel Worksheet Functions | |||
VBA equivalent for WScript.Sleep | Excel Programming | |||
Is there an Excel 2003 equivalent to Word's "versions" function? | Excel Discussion (Misc queries) | |||
Is there an equivalent of Lotus 123's "Paste visible" command? | Excel Discussion (Misc queries) | |||
What would be Excel's equivalent for a Lotus line "[Input].MoveCellPointer $Right,1"? | Excel Programming |