Displaying data on Excel Statusbar?

[Rich]

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

 

[dq]

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

 

[Barb Reinhardt]

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]

Thank you all for your replies

 

[Gord Dibben]

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

 

[Clayman]

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!