Macro CPU Utilization Issue

[bmorgan02]

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

 

[Zurn]

You should use

Application.screenupdating = false

Your forms will be shown normally

 

[Robin Hammond]

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

Robin Hammond
www.enhanceddatasystems.com