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.


--
Information Hog
------------------------------------------------------------------------
Information Hog's Profile: http://www.excelforum.com/member.php...o&userid=21508
View this thread: http://www.excelforum.com/showthread...hreadid=397851

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

--
Regards,
Tom Ogilvy

"Information Hog"
<Information.Hog.1u6gn5_1124733966.4539@excelfor um-nospam.com wrote in
message news:Information.Hog.1u6gn5_1124733966.4539@excelf orum-nospam.com...

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.


--
Information Hog
------------------------------------------------------------------------
Information Hog's Profile:
http://www.excelforum.com/member.php...o&userid=21508
View this thread: http://www.excelforum.com/showthread...hreadid=397851

Thank you for clearing that up.


--
Information Hog
------------------------------------------------------------------------
Information Hog's Profile: http://www.excelforum.com/member.php...o&userid=21508
View this thread: http://www.excelforum.com/showthread...hreadid=397851