If it's helpful my progress bar class has three distinct captions you can
write messages to while your code is progressing.

e.g. you could write

Updating files
FileName
Worksheet

Have a look here
http://www.enhanceddatasystems.com/E...rogressBar.htm

You could easily adapt it to hide the actual progress bar if you are
concerned about showing percentages.

Robin Hammond
www.enhanceddatasystems.com

"Father Guido" wrote in message
...
On Sun, 8 Feb 2004 21:20:20 -0500, "Denny Behnfeldt"
wrote:

I have a lengthy procedure for which I would like to display a
progress bar.
I have seen several excellent variations based on "percentage done".
My problem is that this procedure does a lot of different things that
can't
be easily translated to a percentage. Examples:
It opens another file, formats it by deleting various columns and
rows based
on certain criteria (the number varies between files), closes the
file,
then goes from worksheet to worksheet (8 total) in the original and
deletes
rows to match the new number, opens a different file for another
purpose,
etc.
In other words, couId I use a progress bar to indicate events being
performed, instead of percentage done? Would I estimate the
percentage, and
then update the progress bar (jumping maybe 10% at a time) after each
procedure is done? If this wouldn't work, maybe just keep updating a
MessageBox??
Any ideas on how would I do this?

I know I can use the status bar with text, but it's not very
noticeable.

Any help is greatly appreciated,
Denny


After each section is finished, just update a screen message, turn on
screenupdating, then turn off. Repeat after each section until
finished.