Skip to content

Latest commit

 

History

History
47 lines (29 loc) · 1.17 KB

Excel.Application.StatusBar.md

File metadata and controls

47 lines (29 loc) · 1.17 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.StatusBar property (Excel)
vbaxl10.chm133213
vbaxl10.chm133213
Excel.Application.StatusBar
91b043d7-b320-da4b-bdc7-3be1e1ffe3c6
04/05/2019
medium

Application.StatusBar property (Excel)

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.

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

[!includeSupport and feedback]