Spreadsheet.Text

This property returns the text value of the specified cell.

This property is read only.

Syntax Parameters Return Value 
ReadOnly Property Spreadsheet.Text( _
    CaseNo As Integer, _
    VarNo As Integer) As String
  • CaseNo [in]

The case of the cell.

Type: Integer

  • VarNo [in]

Type: Integer

String

SVB Example

Retrieving the text of a cell: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object 'spr'
    Set spr = ActiveSpreadsheet
    'Returns/sets the numeric value of the specified cell
    MsgBox "the value In the cell(row2, Col3) = " & spr.Text(2,3)
End Sub