Progress Bars

[Information Hog]

How does someone set the % Done on a progress bar if the answere is
always changing? Let's clarify a little bit, I need a progress bar to
act like one does for a printer. multi pages, every time its different
but always end on 100% when done.

One more question. Is it possible to add the name of the worksheet to
the caption of what the progress bar is monitoring at that time? I have
multiple mods and multiple worksheets(names). The worksheet name would
change the macro name would stay the same.

 

[Tom Ogilvy]

You seem to have a misperception.
Progress Bars don't monitor anything. In your code, you pass the percentage
complete to the progress bar (in one form or another), so it is your code
that is determining the percentage complete. The progress bar is only
displaying the information you provide it.

See this simple example at John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip34.htm

 

[Information Hog]

Thank you for clearing that up.