View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Keda Wang Keda Wang is offline
external usenet poster
 
Posts: 5
Default Using the "Ready" Message Bar instead of MSBOX

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



"Keda Wang" wrote in
message ...
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!



.