"Delay" function in Excel
hi,
pause a macro's excecution for a while.
Application.Wait (Now() + TimeValue("0:00:01"))
-----Original Message-----
Hello,
i would like to know if there is a way to have a (non-
freezing, it has
to NOT freeze Excel) delay function in Excel (beside the
loop with
DoEvents).
The problem is that i have a Macro that must "sleep" for
1 second, then
run, then sleep for 1 second, then run, and so on... but
with a DoEvents
loop between each execution the CPU use is ALWAYS 100%.
Is there a not so CPU-hungry way to do it?
Thank you,
Luca
.
|