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

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.
 
M

Mike H

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
 
J

Jon Peltier

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

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top