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


equals vbaworkbooks.open filenamehow to unprotect excel file without passwordvba listbox rowsourceexcel workbook vs worksheetcell color excel formulahow to make a dropdown list in excel 2010excel formulas list 2007scrum spreadsheet templateexcel 2007 workbookunprotect excel 2013excel 2010 delete duplicatesexcel macro paste valuesunlock protected excel spreadsheetprint macro excelexcel vba templateestimating with microsoft excelvb6 listbox columnsunhide hidden columns2014 calendar template excelexcel formulas shortcutsvba code to connect to sql servercompare duplicates in excelcopy data from multiple worksheets into onewhat is excel ribbonkpi dashboard excel templatemacro in ms excelxml converter to excelhow to delete duplicate records in excelapplication vbasurface plots in excelexcel remove workbook protectionhow to unhide sheets in excelautofit row height not workingvba worksheet selectsheets vbac programming viva questions and answers pdfunprotect a workbook without passwordwhat is meant by vlookuplock selected cells in excel 2007eliminate duplicate rows in exceluserform excel 2007advanced vba excelhyperlink to excel cellexcel remove duplicates formularemoving empty rows in excelmerging excel sheets into onedynamic array vba excelsample project plan template excelexcel 2007 chart templatesvba if iserrorexcel if cell equals thenvba access connection stringrun macro on open excelstacked and clustered chart excelexcel logic formulasexcel duplicate cellvba save excel filedeveloper ribbon excelhide formulas in excel 2007unlock excel cells without passwordbar of pie excelexcel insert rowwriting vba macrosvba excel closevlookup returns naexcel project timeline chartarray in excel vbavba saveasadvanced excel shortcuts