Export (0) Print
Expand All
Expand Minimize

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



Community Additions

ADD
Show:
© 2014 Microsoft