DisplayStatusBar Property of Application Object VBA

DisplayStatusBar Application Property in VBA is used to display the status on the status bar. It has Boolean value either True or False. If the value is True it displays the status bar otherwise it stops displaying the status bar. Please find the syntax and examples in the following chapter.

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 DisplayStatusBar Application Property – Syntax

Here syntax for DisplayStatusBar Property of application object in VBA.

Application. DisplayStatusBar

Where DisplayStatusBar as String.
In the above syntax Application represents object and DisplayStatusBar is the Property of Application object.

VBA DisplayStatusBar Application Property: Example 1

Please find the below example for DisplayStatusBar Property of application object in excel VBA. When we run the below macro or procedure, it displays the status on the status bar.

Sub Appl_Display_StsBar_Ex1()
'DisplayStatusBar is the property of application object
Application.DisplayStatusBar = True
End Sub

VBA DisplayStatusBar Application Property: Example 2

Please find the below example for DisplayStatusBar Property of application object in excel VBA. When we run the below macro or procedure, it doesn’t displays the status on the status bar.

Sub Appl_Display_StsBar_Ex2()
'DisplayStatusBar is the property of application object
Application.DisplayStatusBar = False
End Sub

VBA DisplayStatusBar 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.
Step 6: Please notice the above macro results one by one in the status bar for better understand.

LIMITED TIME OFFER

Leave A Comment


Related pages


format excel vbaexcel autofit column widthms access vba msgboxexcel vba row heightconcantenate in excelinsert check mark in excel 2007vba excel saveworkbooks.saveexcel macro developmenthow to protect worksheet in excelactivex combo boxresource planning spreadsheet excelmerge 2 columns in excel 2010refresh pivot table macrodynamic graph excelconstruction project management forms templatesdefinition of vlookup in excel 2007checkbox excel vbaexcel hide cellexcel task templateexcel vba unhide sheetexcel shortcut charthow to remove duplicates in excel 2013how to hyperlink in excelvba create folderproject cost estimate template spreadsheetpivot tutorial excelvba worksheet formulahow to do vlookup in excel 2007 step by stepdata analyst interview questions and answers for freshersexcel vba dynamic arrayproject log template excelvba save excelrecording macros in excel 2007vba sample codecopy to clipboard vbaexcel 2007 graph tutorialinterview questions for beginnershow to crack excel vba passwordapplication enableeventsvba useswait function in vbapivot table in excel 2007 with example xlsproject schedule template xlsvba pivottableexecutive dashboard template freepowerpoint donut chartcosting template excelwhat are dml commandsadd the developer tab to the ribbonhow does vlookup work in excel 2013monthly schedule template excelexcel formulas tutorialinsert checkbox in excel 2007macro basics excelprotecting a workbook in excelexcel bubble plotcopy to clipboard vbavba open workbookhow to lock an excel fileexcel vba windowchange width of column excelcopy and paste cells in excelshortcut key insert row excelhow to use vlookup in excel 2003 step by stepmeeting minutes template word 2010merge tabs excelvba timer functionshortcut key to insert row in excel 2010isblank functionkpi gauge excelvlookup function excelvba datediffunlock excel password protected fileexcel vba operatorspowerpoint swot analysis templateproject schedule gantt chart excel templatemsg vba