DisplayFormulaBar Property of Application Object VBA

DisplayFormulaBar Application Property in VBA is used to hide or show the formula bar. It has Boolean value. If the value is true then it show the formula bar on the Excel screen. Else, it hides the formula bar. Please find the more information and syntax 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 DisplayFormulaBar Application Property – Syntax

Here syntax for DisplayFormulaBar Property of application object in VBA.

Application. DisplayFormulaBar

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

VBA DisplayFormulaBar Application Property: Example 1

Please find the below example for DisplayFormulaBar Property of application object in excel VBA. The below example shows the formula bar in the Excel screen.

Sub Appl_Display_FrmlBr_Ex1()
'DisplayFormulaBar is the property of application object
Application.DisplayFormulaBar = True
End Sub

VBA DisplayFormulaBar Application Property: Example 2

Please find the below example for DisplayFormulaBar Property of application object in excel VBA. The below example hides the formula bar in the Excel screen.

Sub Appl_Display_FrmlBr_Ex2()
'DisplayFormulaBar is the property of application object
Application.DisplayFormulaBar = False
End Sub

VBA DisplayFormulaBar 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 window.
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 macro code to display formula bar or not.

LIMITED TIME OFFER

Leave A Comment


Related pages


writing macros in wordvba fileexcel vba protect all sheetsapplication.inputboxvba excel casefrequently asked aptitude questions in interviewvba application.runexcel to xml conversionaccess macros tutorialexcel check for duplicatelock excel workbookvba variable typesexcel vba msgboxfree excel dashboard templates 2010how to highlight column in excelmessage box vba accessinsert alternate blank rows in excelexcel formula list with examples 2007excel function hlookupuse of vlookup and hlookuphorizontal lookup excelhide sheets in excel vbahow to combine data from multiple worksheets in excel 2010vba connect to sql databasehlookup excelvlookup stepscreate pie chart in excel 2013conditional vlookuphow to create check box in excelms excel functions with exampleshow to do a pivot table in excel 2013inserting multiple rows in excelexcel vba break for loopexcel range vb netoutlook vba codeexcel workbook worksheetcode vbapastespecial xlpastevalueshow to build dashboards in exceldml and ddl commands in sql serverhow to check duplicates in excelconditional formatting excel 2007 if statementexcel vba messageboxhow to protect ms excel 2007 with passwordadvanced excel formulas with examples in excel sheetpastespecial pastecreate a checkbox in excelhow to delete a worksheet in excelpivot table advanceactivesheet unprotect password vbausing sql in excel vbainsert drop down box in excel 2007how to remove password protection from excel 2010 workbookoutlook vba referenceword vba programmingvba spreadsheet controlexcel macro rename sheetconstruction cost estimator excelcountif in excelpyramid powerpoint templatehow to find duplicates in excel 2007excel copy cellsexcel template project planvlookup code in vbarows excel vbahow to put a tick box in excelunprotect all sheets exceldraw charts in excelmacro commands excelvba code to open a fileexcel vba database examplesdatabase languages ddl dml dcl