Best way to pause?

R

Ramthebuffs

I am running a WinHttp.WinHttpRequest and would like to pause in between
loops. Currently I have Application.Wait Now + TimeSerial(0, 0, 5)
During the pause the CPU gets up to 100% and remains there until the
pause is done. Is there a better way to put a pause in a macro that is
less taxing on the CPU?
 
R

Ramthebuffs

I've tried this but it seems to freeze in excel Application.OnTime Now
TimeSerial(0, 0, 5), "GetResults
 
R

Ramthebuffs

the Ontime function does work, but it doesn't show screen updates or
allow me to work with excel when its running. Here is what I have with
Ontime Application.OnTime Now + TimeSerial(0, 0, 5), "GetResults"
Have I not entered it correctly or something? Is it freezing because
its set for a short period of time?
 

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

How to pause without being "modal" 1
How to Pause an Excel VBA script without freezing excel 1
Stop / Pause a Macro using Pause button 4
Pause a macro by resetting current time 3
Funcitonality to pause macro?! 13
Best way to use the Document Shape 0
Stop running macro button, like Ctrl-Break button 8
Countdown macro - display settings 2

Top