Using the "Ready" Message Bar instead of MSBOX

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!
 
C

Chip Pearson

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
 
K

Keda Wang

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...
 
B

BrianB

Application.StatusBar="My Message String"

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