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

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> HOW TO CHANGE THE VALUE IN STATUS BAR?