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

"Gum" wrote:

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mike H" <(E-Mail Removed)> wrote in message
news:9B916619-C02E-4C27-B271-(E-Mail Removed)...
> 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
>
> "Gum" wrote:
>
>> 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.