Progress Bar

[Joanne]

I have a rather long macro that does a lot of reformatting. Is there a way
to show a progress bar for the macro so the user knows how much longer he has
to wait?

Thanks in advance for your help.

 

[Karl E. Peterson]

I have a rather long macro that does a lot of reformatting. Is there a way
to show a progress bar for the macro so the user knows how much longer he has
to wait?

Probably. You'll need to be able to calculate the time remaining, of course. To do
this, I suppose you'll have to know approximately what percentage complete your task
is, and how long it's been since it started. Then, you'll need to call a routine
that updates the progress bar with this value. Lather, rinse, repeat.

 

[Greg Maxey]

Joanne,

There is an example of a userform used as a progress bar here:
http://gregmaxey.mvps.org/Ribbon_Gallery_Control.htm

The problem has Karl says is that the macro may have no idea how much more
time it needs to complete the job. About all you can do is guestimate how
much time to allow for the job and progress accordingly or use something
static like a status bar mesage