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

--
Regards,
Tom Ogilvy

"Information Hog"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Information Hog]

Thank you for clearing that up.