EXCEL STATUS BAR

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
Back
Top