StatusBar Property of Application Object VBA

StatusBar Application Property in VBA is used to sets or returns the text in the status bar. StatusBar text will appear left bottom corner of the window. Please find the more information about StatusBar in the following section.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


VBA StatusBar Application Property – Syntax

Here syntax for StatusBar Property of application object in VBA.

Application. StatusBar

Where StatusBar as Variant data type.
In the above syntax Application represents object and StatusBar is the Property of Application object.

VBA StatusBar Application Property: Example 1

Please find the below example for StatusBar Property of application object in excel VBA. The below example displays the message like “Please wait, Processing the request…” in the StatusBar. You can have a look into it in the left bottom corner of the Excel window.

Sub Appl_StatusBar()
Application.StatusBar = "Please wait, Processing the request..."
End Sub

VBA StatusBar Application Property: Example 2

Please find the below example for StatusBar Property of application object in excel VBA. The below example does not display anything in the statusbar.

Sub Appl_StatusBar_Empty()
Application.StatusBar = ""
'OR
Application.StatusBar = False
End Sub

VBA StatusBar Application Property: Example 3

Please find the below example for StatusBar Property of application object in excel VBA. Please find the one more example, it displays the message like “Please wait, Processing the request…” in the StatusBar.

Sub Appl_StatusBar3()
‘Displays the status in the StatusBar
Application.DisplayAlerts = True
‘Status message in the StatusBar
Application.StatusBar = "Please wait, Processing the request..."
‘It displays the default Excel status message in the StatusBar
Application.DisplayAlerts = False
End Sub 

VBA StatusBar Application Property – Instructions

Please follow the below steps to execute the VBA code to save the excel file.
Step 1: Open any existing Excel Application.
Step 2: Press Alt+F11 – This will open the VBA Editor.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 5: Now press F5 to execute the code and observe the screen updating with using above codes.

LIMITED TIME OFFER

Leave A Comment


Related pages


how to insert a check box in excelset row height in excelexport xlsx to xmlbasics of excel macrosexcel autorun macrovba code loophow to remove duplicate emails in excelcombine data from multiple tabs into onevba code to save workbookvba runtime error 1004 application defined or object defined errorvba sqrt functioncreate userform in excelifs function in excelno of rows and columns in ms excelvb scripts in excelinsert rows excelms excel vlookup examplevlookup rangeexcel macro gotoado database connectionunprotect excel sheet passwordvba code examplefind duplicate rows in excelcool excel dashboardsexcel find duplicatesexcel vba tabexcel vba data typeexcel formula explainedpublic variables vbaxlsm file downloadexcel workbook vbaunprotect excel documentuserform excel 2007excel 2013 if statementvariables in excel vbavba crlfpivot tables vbavba code to open excel fileexcel estimate templatemeeting agenda template powerpointexcel range macroexcel vba last rowexcel pivot table auto refreshpricing model template in excelhow to do a pivot table in excel 2007excel offset vbaexcel concatenateexcel value lookupexample sumif excelexcel vba offset named rangesurface plots in excelexcel vba userform tutorial pdf2 if statements in excelmicrosoft excel macro tutorialdeleting duplicates in excelexcel insert row shortcutdml statements in sqlvb macrosapplication filedialog msofiledialogfilepickerdcl languageexcel formulas and functions for dummiesvba colorindexcreating a simple macro in excel 2010recordset excel vbaddl queries in sqlvba programming courseinsert developer tab in excel 2010definition of hlookupexcel vba saveasdashboard widgets for excelconverting excel to csvvba positionoutlook macro examplesdelete entire row vbaexcel macro basicsdatevalue vbaadvanced vlookupmacro to unlock password protected workbookexcel check boxexamples of if statements in excelvba excel macrosduplicate records in excelwhat is the countif function in excel