Export (0) Print
Expand All
Expand Minimize

Application.StatusBar Property

Office 2007
Returns or sets the text in the status bar. Read/write String.

Syntax

expression.StatusBar

expression   A variable that represents an Application object.

Remarks

This property returns False if Microsoft Excel has control of the status bar. To restore the default status bar text, set the property to False; this works even if the status bar is hidden.

Example

This example sets the status bar text to "Please be patient..." before it opens the workbook Large.xls, and then it restores the default text.

Visual Basic for Applications
oldStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Please be patient..."
Workbooks.Open filename:="LARGE.XLS"
Application.StatusBar = False
Application.DisplayStatusBar = oldStatusBar



Community Additions

ADD
Show:
© 2014 Microsoft