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


working with macros in excel 2007excel sheet name in cellpivot table tutorial excel 2010vba combobox multiple columnsddl dml sqlhow to use vlookup in excel 2010 step by stepexcel macro countadvantages of ms excelfree excel dashboard templatevlookup example 2010excel vba programming booksexcel vba combobox additemhow to program vbamacro to unlock excelexcel visual basic tutorial for beginnersvba sheetmacro to combine worksheetsexcel shortcut to delete rowhow to convert xls to xml formatexcel months between two datesvba listbox rowsourceaverage vbamanaging multiple projects excel templateexcel list boxif clause in excelvba readlineexcel vba input boxvba sort rangesql interview questions advancedcharttype vbavba macro wordleft function vbaexcel remove rows containingwhat is a countif function in excelconnection vbainsert macro excelremove workbook protectionsas and sqldeclaring array in vbalookup and reference in excelexcel macro saverun macro on open excelobject oriented programming vbavlookup with and functiontraining schedule template excelexcel vba project examplesdashboard report excelif statements in excel 2010excel macro saveasexcel graph filtervba excel printisempty excelvba sub procedurevba workbook objectproject tracker template excel freeusing vba in excel 2007explanation of excel formulassales dashboard examples excellookup functions in exceldeleting empty rows in excelhow do i unhide column a in excel 2010sendmail command examplevba statementsiserror functionms access vba delete recorduseful vbs scriptsvba while statementbusiness analyst interview questions and answers for experiencedunlock excel 2007 passwordbuilding macros in excel 2010simple example of vlookup in exceldelete a row vbaexcel template schedule plannerremove duplicate entries in excelvlookup between two workbooksschedule spreadsheet template excelnot iserrorhow to learn vbadebug print vba