Displaying data on Excel Statusbar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
Back
Top