Caption property as it applies to the ChSeries, ChTitle, ChTrendline, Heading, Spreadsheet, PivotField, PivotFieldSet, PivotLabel, PivotMemberProperty, PivotTotal, and TitleBar objects.Returns or sets the caption for the specified object. Read/write String.
expression.Caption
expression Required. An expression that returns one of the objects listed above.
Returns the caption for the specified object. Read-only String.
expression.Caption
expression Required. An expression that returns one of the objects listed above.
Example
As it applies to the Spreadsheet object .
This example displays the current date and time in the title bar of Spreadsheet1.
Sub SetTitleBar_Caption()
Dim ssTitle
Set ssTitle = Spreadhseet1.TitleBar
' Set the title bar's caption to the
' current date and time.
ssTitle.Caption = Date & " " & Time
' Enable the title bar.
ssTitle.Visible = True
End Sub