View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
StargateFanFromWork[_4_] StargateFanFromWork[_4_] is offline
external usenet poster
 
Posts: 51
Default 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