"Jamie Collins" wrote in message
om...
"Dick Kusleika" wrote in ...

Do
Loop Until Now dtStart + TimeSerial(0, 0, 10)

You'd want a DoEevnts in there.

Why is that? I see that all the time, but I'm not really trying to do
anything here, so I'm not sure why I need it. Just curious.

Ever find yourself waiting for a application to finish a long process,
so you decide to switch to another app while you're waiting but you
can't because that long process is hogging all the machine's
resources? If that app did the equivalent of a DoEvents every now and
again the OS would do a better job of sharing.

Oh, "other" applications. That makes sense.


That said, on reflection the loop above will be called thousands of
times in ten seconds so calling DoEvents on each iteration is probably
excessive.

I'd consider the Sleep API to be the best solution because for the
duration the application should take no extra resources.


Concur. Thanks.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com