Is there a way to WAIT in Excel without using 100% CPU?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using the Application.Wait command in Excel, CPU utilization goes to
100% for the duration of the wait command. Is there a better way?
 
Hello, Marc

you could split your macro into two procedures, the first of which
consisting of everything ahead of your application.wait command and the
second one consisting of everything after it. Then, in the first
procedure you could use the application.ontime command to call the
second procedure with a certain time delay. This may also require some
modification concerning the declaration (validation) of variables, but
other than the application.wait command it doesn't require much CPU
utilization.

Regards
Ingolf
 
You must log in or register to reply here.

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

Similar Threads

Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Best way to pause? 2
Youtube is a problem 6
Macro problems: Waiting for site to load and commanding Save todownload prompt 5
Are my CPU temps normal? 1
sheet event wait for another event? 6
Force Macro to wait till Refreshall is done 4
Need help! Cpu usage at 100% after startup 8

Back
Top