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?