Neil Hopkinson wrote:
Hello,

I have written a macro which performs some lengthy calculations. I run the
macro then tell excel to calculate. Running the macro takes about 10 seconds,
calculating takes up to 1 minute. I want to display a progress bar to show
the calculation progress so the user knows the program hasn't crashed.
Obviously this is displayed in the bottom left hand corner but is it possible
to display it more obviously?

Many Thanks


The low-tech solution is to just write a status message out to a visible, unused
cell on your worksheet and update it each pass through the loop. Make it in
color if you wish to be more eye-catching. There are various reasons this won't
work for all cases, but when this approach does fit your problem it's dirt
simple to do.

Bill