Status bar in Excel 2010

[GWC]

How can I get the green progress bar to be displayed?

 

[merjet]

If it isn't shown on your controls toolbox, then click on "more controls" or right-click and click "additional controls", then choose Microsoft ProgressBar Control.

 

[GWC]

If it isn't shown on your controls toolbox, then click on "more controls"or right-click and click "additional controls", then chooseMicrosoft ProgressBar Control.

What do I click to see "more controls"?
or what do I right-click to see "additional controls"?

 

[merjet]

What do I click to see "more controls"?

or what do I right-click to see "additional controls"?

ProgressBar on worksheet: Developer | Insert controls | click on hammer-wrench icon.
ProgressBar on UserForm: Developer | Visual Basic | right-click on Toolbox, which appears with a UserForm

If Developer doesn't appear as a menu item, see Help to get it.

 

[GS]

merjet explained :

ProgressBar on worksheet: Developer | Insert controls | click on
hammer-wrench icon. ProgressBar on UserForm: Developer | Visual Basic |
right-click on Toolbox, which appears with a UserForm

If Developer doesn't appear as a menu item, see Help to get it.

I believe Gary is talking about the Excel StatusBar!!!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[merjet]

I believe Gary is talking about the Excel StatusBar!!!

Maybe, but the first post says "progress bar."

 

[GS]

merjet used his keyboard to write :

Maybe, but the first post says "progress bar."

Yeah, he posted the same Q in another NG that included more info...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GWC]

merjet used his keyboard to write :



Yeah, he posted the same Q in another NG that included more info...

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

I must be blind.

When I click on Developer, click on Insert controls and click on the
hammer-wrench icon, I get a list of controls.

Which control do I select so the green progress bar is displayed on
the Status Bar?

[In Excel 2007, the green progress bar was displayed on the Status Bar
and it showed how far a process (like saving, calculating, adding
subtotals, etc) has progressed].

 

[GS]

GWC pretended :

merjet used his keyboard to write :


Yeah, he posted the same Q in another NG that included more info...

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

I must be blind.

When I click on Developer, click on Insert controls and click on the
hammer-wrench icon, I get a list of controls.

Which control do I select so the green progress bar is displayed on
the Status Bar?

[In Excel 2007, the green progress bar was displayed on the Status Bar
and it showed how far a process (like saving, calculating, adding
subtotals, etc) has progressed].

None. The Excel StatusBar is managed by Excel but some of its
properties and methods are exposed to VBA and/or automation. AFAIK, the
only thing we can do is set the text it displays.

If you are following Auric's suggestion you won't find a ProgressBar
control where he sent you unless you have a licensed copy of Visual
Studio installed, OR if you happen to have a 3rd party OCX that's
registered on your machine. If you just want to display a progress bar
in a userform then visit j-walk.com to download a sample.xls that you
can modify for your use!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion