my message in Status bar

[Anita]

hello,
please tell, whether it possible - to post my own message
to the Status Bar.

Thank you very much,
Anita

 

[Norman Jones]

Hi Anita,

To add:

Application.StatusBar="My Message"

To remove:

Application.StatusBar=""

 

[Bob Flanagan]

Anita, use

Application.Statusbar =False

to erase the statusbar message. Setting ="" just puts a null value in the
status bar, which prevents system status messages from appearing.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Norman Jones]

Hi Bob

Anita, use
Application.Statusbar =False

to erase the statusbar message. Setting ="" just puts a null value in the
status bar, which prevents system status messages from appearing.

This is not my experience.

From Intermediate window:

Application.StatusBar="My Message"
?Application.StatusBar
My Message

Application.StatusBar=""
?Application.StatusBar
False