Progress Bars

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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 work*** 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?action=getinfo&userid=21508
View this thread: http://www.excelforum.com/showthread.php?threadid=397851

.

Quantcast