Caption Property of Application Object VBA

Caption Application Property in VBA represents the name of the title bar that appears in the main Excel widow. If you don’t mention title bar, it displays as “Microsoft Excel”.



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 Caption Application Property – Syntax

Here syntax for Caption Property of application object in VBA.

Application. Caption

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

VBA Caption Application Property: Example 1

Please find the below example for Caption Property of application object in excel VBA. The below macro displays the caption in the title bar.

Sub Appl_StatusBar()
‘It represents the caption message 
Application.Caption = "Demo of"
End Sub

VBA Caption 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 and find the caption in the title bar window.


Leave A Comment

Related pages

color code in vbaexample macro excellen function excelautofit in excel 2010vba script exceltwo dimensional array in vbaexcel remove doubleswhat is operand and operatorcan you find duplicates in excelwhat is vlook up in excelcheck box vbaexcel test for nullvba select last rowcool macros for excelremove zeros in excelms access vba run query with parameterspurpose of pivot tables in excelcreate vba excelvlookup basicsvba entirerowsample project plan mppfso delete filepivot table in excel 2007 with example pptpowerpoint macro tutorialvba write to excelhow to sort numbers in ascending order in excelunhide column excel 2010how to use sumif in excel 2007vba file copyms excel 2007 vlookupdelete duplicates in excel columnvba scriptcase when vbaexcel vba lastrowsql interview question answer pdfexcel autoexec macroexcel cell function colorvba excel select cellcreate calculator in excelvba code excelvba unload megantt chart template free microsoft wordunprotect excel filevlookup with choose functionhow to unhide in excel 2013excel vba macro buttonhow to delete numbers in excelbest excel vba book for beginnersinterview questions on testing for freshersinsert a check box in excelexcel interactive chartsql mcq questions with answers pdfinteractive calendar excelexcel consolidationexcel draw chartdml in databasems excel vba programmingdynamic dashboard excelexcel sorting numberssql query in vbamerge sheets excelexcel formulas matchvba count cellscreate pivot in excelcopy sheet vbavba user defined functionunderstanding vlookupexcel interactive calendarinput box vbasql orderedmultiple stacked bar chart excel 2010excel vba access queryvba sample code