Macro CPU Utilization Issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Relevant Pages

  • (C) Simulated progress bar
    ... for him has asked me if I could get the program to pause for a second ... between turns and to display a progress indicator to make it look like the ... for loop, set up to display a bunch of hashmarks or ASCII block characters ...
    (alt.comp.lang.learn.c-cpp)
  • Activate a form ?
    ... I have a form that I use for a progress indicator. ... This works fine the first time, but I want to be able to display the ... the event Private Sub UserForm_Activate. ... can I initiate the code a second time if the form is already shown? ...
    (microsoft.public.excel.misc)
  • Re: Display of Command execution.
    ... i think there's an ms patterns implementation on a similar point. ... > complaining i want to display an progress indicator. ...
    (microsoft.public.dotnet.framework.adonet)