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


using trim in excelvba xlupmerging in excelsimple excel exercises for beginnersvba listbox userformvba excel find character in stringcreating vba macros in excel 2010how to use vlookup function in excelhow to use datevalue function in excelcool excel vbaexcel vba call functionvba open pdfreference excel cell in vbavba coding tutorialmis executive interview questions and answers pdfvbscript to copy files from one folder to anotherfso filecopyvlookup function examplesbox plot excel 2010 templatelookup function on excelunlock excel password protected fileexcel vba clipboardhow to unhide the first column in excelvba open access databaserun sql in excelinsert button exceldefinition of vlookupms access delete duplicate recordsvba object propertiessteps in creating a chart in excelsum if function in excelvba switch statementvba examples excelexcel userforms for data entryexcel activeworkbook.saveasvba range selectionexcel vba switch statementcopy range vbaexcel vba close filevba fileformatremove duplicates macromicrosoft excel check boxvba and conditionsaveas vba excelpassword spreadsheet templateprotect formulas in excelproject management powerpoint presentation templatevlookup refexcel password cracker macroexcel vba for dummies pdfunprotect the excel sheetwhat is the lookup function in excelcool vba macrosinsert a title in excelin excel vlookup formula examplehow to use the lookup function in excelinterview questions on sql for freshersunprotect worksheet without passwordlearning macros in excel 2007project plan calendar template exceljoin rows in excelddl queryexcel macro find last rowvba if elseifhow to delete a button in excelexcel cell mergeexcel odbc querylistbox in excelnot iserrorexcel find duplicates formula