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

connection string vbacomment excel vbaunhide all columnsmicrosoft excel match functionusing if statements in excelexcel vlookup tutorialexcel hyperlink functionsubtract two dates in excelsql questions and answers for experiencedvba continue forexcel action item templateactivate sheet vbaexcel vba save as xlsxhide worksheetauto filter definitionsoftware development estimation templateapplication filedialogexcel dedupe formulaproject milestone templatecheck duplicates in excelvba gotopassword protect vbaadd the developer tab to the ribbon on wordhow to unhide column a in excel 2007vba excel delete rowoutlook macro examplesactivate activexworkbooks closeexcel macro variablehow to use excel match functionhow to insert row in excel shortcut keyunprotect cells in excelvba copy worksheet to another workbookmessagebox custom buttonscountif excelexcel vba create new workbookdisplay developer tabdelete activex controlvba continue forrun a macro in excelhow to use pivot table in excel 2010 with examplevb code to open a fileunhide sheetsexcel vba activecelladvanced excel vba traininghow to delete cells in excelunhide worksheet excel 2010copy a worksheet to another workbookbeginners excel tutorialcolor index excel vbaprotected sheet excelfind duplicates excel 2003execute sql query from excelexcel vba printsort selected cells by last name in ascending orderxls macro tutorialthe macros in this project are disabled excel 2007how to record macros in excelvba project downloadhow to do a vlookup on excel 2010microsoft excel trend analysiscarriage returns in excelvba code looploops in excelexcel vba isemptychanging row to column in excelhow does vlookup work in excel 2007for loop vbagantt chart excel download freeexamples of spread sheetsremove duplicate excel 2010how to remove a drop down box in excelgenerate xml from excelexcel macro to open a fileword macros examplesexcel vba progress barexcel forms tutorialexcel macro enabled workbookcombobox propertieshow to run a macro in excel 2007