Hello,

Does Excel have any function like the SysCmd function in MS Access for
displaying data in the Excel Statusbar? Is it possible to display data in
the Excel statusbar or make like a progres meter?

How to do this?

Thanks,
Rich

On 17 apr, 20:18, Rich <R...@discussions.microsoft.com> wrote:
> Hello,
>
> Does Excel have any function like the SysCmd function in MS Access for
> displaying data in the Excel Statusbar? Is it possible to display data in
> the Excel statusbar or make like a progres meter?
>
> How to do this?
>
> Thanks,
> Rich

Use (in VB) Application.Statusbar = "My message" to display a message
and Application.Statusbar = False to remove it.
To make a progressbar you can work with something like "Processing
XXoooooo" to "Processing XXXXXXXX"

DQ

Use the following:

Application.Statusbar = FALSE 'to turn off'
Application.Statusbar = "Enter your comment" 'to display at the Lower Left
corner of the Excel window.

"Rich" wrote:

> Hello,
>
> Does Excel have any function like the SysCmd function in MS Access for
> displaying data in the Excel Statusbar? Is it possible to display data in
> the Excel statusbar or make like a progres meter?
>
> How to do this?
>
> Thanks,
> Rich

Thank you all for your replies

"Rich" wrote:

> Hello,
>
> Does Excel have any function like the SysCmd function in MS Access for
> displaying data in the Excel Statusbar? Is it possible to display data in
> the Excel statusbar or make like a progres meter?
>
> How to do this?
>
> Thanks,
> Rich

Check out VBE help on Application.StatusBar

For a progress bar on status bar see David McRitchie's site

http://www.mvps.org/dmcritchie/excel/statusbar.htm

For a userform see John Walkenbach's site.

http://www.j-walk.com/ss/excel/tips/tip34.htm


Gord Dibben MS Excel MVP

On Tue, 17 Apr 2007 11:18:04 -0700, Rich <(E-Mail Removed)> wrote:

>Hello,
>
>Does Excel have any function like the SysCmd function in MS Access for
>displaying data in the Excel Statusbar? Is it possible to display data in
>the Excel statusbar or make like a progres meter?
>
>How to do this?
>
>Thanks,
>Rich

"Gord Dibben" wrote:

> For a progress bar on status bar see David McRitchie's site
>
> http://www.mvps.org/dmcritchie/excel/statusbar.htm
>
>
> Gord Dibben MS Excel MVP
>
Oh, man! This is so cool!

I've got a procedure that takes about 8 minutes with screen-updating turned
off. People are looking at me like it's frozen. So, I put in the progress bar
- and now they are happy again!

Sweet!