View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luca T. Luca T. is offline
external usenet poster
 
Posts: 4
Default "Delay" function in Excel

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