View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Status bar in Excel 2010

GWC pretended :
On Apr 11, 8:42*am, GS wrote:
merjet used his keyboard to write :

I believe Gary is talking about theExcelStatusBar!!!
Maybe, but the first post says "progressbar."


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