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

visual basic commands excelremove hyperlink from excelvba create new workbookexcel 2010 project plan templateaccess vba programming pdfexamples of ddlexcel macros 2007insert row excel 2007microsoft excel graph tutorialexcel programmerbest excel dashboard examplesvba excel option buttonaccess vba multidimensional arrayvba interior.colorindexpowerpoint macro examplesactivecell columnvba stockdays360 functionvba getrowsexcell shortcutsvisual basic excel macrocreating an excel macroexcel default templatedashboard powerpoint template freechecklist template excel 2007excel 2010 name managerpaste function in excelexcel formula in vbavba string to doublelogical formulas in excel 2007vba userformsschedule template powerpointsas books for beginnerscombobox in excelmacro recorder excelexcel macro active sheetcost estimate spreadsheet templatecountif excel vbahow to unprotect exceludf vbaproject milestone template excelcost analysis spreadsheet exceldynamic dashboard excelgantt chart free downloadtrim in excellearn vba for accessclose userform vba excelcount if examplevba sumifadding a drop down in excelexcel vba activeworkbook saveascolorindex vbashade cells in excelremove workbook passwordhow to unshare a workbookexcel remove duplicates in a columntask tracking template excelclose excel in vbamacro code excel2007 excel templatesexcel vba instr functionvbscript excel saveasmicrosoft excel how to merge cellsvba inputexcel vba for beginnersremoving duplicate cells in exceloption button excel vbasql advanced concepts with examplesexcel vba column rangeexample of vlookup functionexcel vba integer rangeexcel 2010 iferrorhow to check for duplicates in excelrun a macro in excelvba copy rangeexcel vba create new workbookexcel tabs in alphabetical orderswot analysis ppt templatevba docmd