Using the "Ready" Message Bar instead of MSBOX

  • Thread starter Thread starter Keda Wang
  • Start date Start date
K

Keda Wang

I know it is possible to output messages on the "Ready"
bar (located on the bottom of the screen) instead of using
pop-ups (MsgBox).

Does anyone know how to do this? If so, please share.
Thanks!
 
Ked,

You can use status bar to display messages. For example,

Application.StatusBar = "Hello World"

To return control of the status bar back to Excel, use

Application.StatusBar = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Perfect! Thanks Chip!

-Keda
-----Original Message-----
Ked,

You can use status bar to display messages. For example,

Application.StatusBar = "Hello World"

To return control of the status bar back to Excel, use

Application.StatusBar = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






.
Click to expand...
 
Application.StatusBar="My Message String"

Reset it at the end of the macro with :=
Application.StatusBar=False
 
Back
Top