Range.Text Property

  • Article
Excel Developer Reference

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

See Also