DisplayFullScreen Property of Application Object VBA

DisplayFullScreen Application Property in VBA is used to display Excel screen in full screen mode and hides the application title bar. It has Boolean value either True or False. When the value is true the Excel screen in full screen mode. 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


DisplayFullScreen Application Property in VBA is used to

VBA DisplayFullScreen Application Property – Syntax

Here syntax for DisplayFullScreen Property of application object in VBA.

Application. DisplayFullScreen

Where DisplayFullScreen as String.
In the above syntax Application represents object and ‘DisplayFullScreen’ is the Property of Application object.

VBA DisplayFullScreen Application Property: Example 1

Please find the below example for ‘DisplayFullScreen’ Property of application object in excel VBA. The below example maximizes the Excel screen.

Sub Appl_Display_FulScrn_Ex1()
'DisplayFullScreen is the property of application object
Application.DisplayFullScreen = True
End Sub

VBA DisplayFullScreen Application Property: Example 2

Please find the below example for ‘DisplayFullScreen’ Property of application object in excel VBA. If the Excel screen is full screen mode, then the below example minimizes or normal Excel screen.

Sub Appl_Display_FulScrn_Ex2()
'DisplayFullScreen is the property of application object
Application.DisplayFullScreen = False
End Sub

VBA DisplayFullScreen 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 above code.
Step 6: Observe the Excel screen windows by running above two macros.

LIMITED TIME OFFER

Leave A Comment


Related pages


rank vbabubble charts excelcreate a checklist in excelcase else vbaif iserror vlookup excel 2010explain vlookup in excelexcel vba delete entire rowhow to protect an excel worksheetvlookup formula in excel 2007how to join rows in exceldeclaring variables in vbaexcel 2003 macrosloop until vbauserforms excelexcell sumiffor vba loopvb scripting interview questions and answersexcel vba userform refreshclose file vbacountifs function excel 2010vba code in excelsort excel spreadsheet by columnrca template wordrun query from vbapivot table in excel 2007 tutorialhow to open excel file in xml formatms access vba tutorial pdfremove characters excelcolor vbadynamic excel chartsbasic excel macrosscrum spreadsheet templatevba active worksheetclustered column chart excel 2013sql select excelxml generator from excelvba excel queryexcel combobox vbaexcel task management templatevbcrlf in vbav look up exampleaccess vba insert into table from formhow to start vba in excellookup function on excelcapacity planning template in excel spreadsheetaccess 2007 developer tabhow to copy data validation to other cellsexcel unprotect sheet password recoveryexcel pivot table templatehow to unlock an excel filewhat is ddl and dml in sql serverproject progress report template excel2500 excel vba examplesleft in vbaduplicate records in excelexcel vba menuproject plan template word docexcel remove duplicate cellsvba debug printexcel reporting templates dashboardhow to lock a spreadsheetexcel vba access queryexcel presentation templateshow do you hyperlink in excelvb exit forexcel find duplicate rowsproject tracking template exceltechnical interview questions for freshersms excel operatorsexcel vba interfaceusing excel advanced filterview developer tab in excelexcel password vbamicrosoft excel graph tutorialmacro basics excelcompare dates vba