This documentation is archived and is not being maintained.

Range.Text Property

Office 2007
Returns or sets the text for the specified object. Read-only String.

Syntax

expression.Text

expression   A variable that represents a Range object.

Example

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

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



Show: