Thread: Using the "Ready" Message Bar instead of MSBOX
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Using the "Ready" Message Bar instead of MSBOX
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!


Reply With QuoteReply With Quote