Text Property

Microsoft Excel Visual Basic

Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects.

For information about using the Text worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic.

Remarks

For the Phonetic object, this property returns or sets its phonetic text. You cannot set this property to Null.

Example

This example sets the text for the chart title of Chart1.

With Charts("Chart1")
    .HasTitle = True
    .ChartTitle.Text = "First Quarter Sales"
End With
		

This example sets the axis title text for the category axis in Chart1.

With Charts("Chart1").Axes(xlCategory)
    .HasTitle = True
    .AxisTitle.Text = "Month"
End With
		

This example illustrates the difference between the Text and Value properties of cells that contain formatted numbers.

Set c = Worksheets("Sheet1").Range("B14")
c.Value = 1198.3
c.NumberFormat = "$#,##0_);($#,##0)"
MsgBox c.Value
MsgBox c.Text