ExcelBanter - EXCEL STATUS BAR

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - EXCEL STATUS BAR (https://www.excelbanter.com/setting-up-configuration-excel/99607-excel-status-bar.html)

QUERIES

EXCEL STATUS BAR

HOW TO CHANGE THE VALUE IN STATUS BAR?

Bob Phillips

EXCEL STATUS BAR

Dim oStatusBar
oStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Please be patient..."
MsgBox "Break to demonstrate"
Application.StatusBar = False
Application.DisplayStatusBar = oStatusBar

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"QUERIES" wrote in message
...
HOW TO CHANGE THE VALUE IN STATUS BAR?

All times are GMT +1. The time now is 07:17 AM.