Can the Application.wait method create a pause less than a second?

  • Thread starter Thread starter Gum
  • Start date Start date
G

Gum

I have often read that the application.wait method of introducing a pause in
a thread is limited to a second or multiples thereof. Is this true? If it
is true, then is there an alternative. If not, then how is the familiar
'timevalue()' written so that it accesses values that represent a part of a
second.
 
Hi,

I don't believe application.wait can discriminate less than 1 second but
maybe this

Sub SlowDown()
Dim x As Single
x = Timer
While Timer - x < 0.5
Wend
End Sub

Mike
 
And if you stick a DoEvents between While and Wend, you won't completely
freeze up the machine while waiting.

- Jon
 
Back
Top