Macro CPU Utilization Issue
 

I'm using Walkenbach's Progress Indicator form to display the progress
of a fairly complicated macro I've written. It would work fine, except
that when I run it my CPU utilization shoots up to 100% for over 5
minutes and my Progress Indicator/Excel freezes until completion. So
this nice progress indicator I've built in is now basically useless.
Does anyone know a workaround?

Secondly - are Userforms/repainting of forms subject to the
ScreenUpdating=False?

Thanks!

Brad

Macro CPU Utilization Issue
 

You should use

Application.screenupdating = false

Your forms will be shown normally


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=533594

Macro CPU Utilization Issue
 

More likely, you need a DoEvents statement somewhere within the loop.

Robin Hammond
www.enhanceddatasystems.com

"Zurn" wrote in message
...

You should use

Application.screenupdating = false

Your forms will be shown normally


--
Zurn
------------------------------------------------------------------------
Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=533594