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

Thank you very much,
Anita

Hi Anita,

To add:

Application.StatusBar="My Message"

To remove:

Application.StatusBar=""

---
Regards,
Norman



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

Thank you very much,
Anita

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

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

Thank you very much,
Anita

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


---
Regards,
Norman



"Bob Flanagan" wrote in message
...
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

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

Thank you very much,
Anita