Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. The Text property returns a string that represents the text as displayed in a cell
Sub text()
    MsgBox Worksheets("Sheet1").range("A1").text
    MsgBox Worksheets("Sheet1").range("A1").value
End Sub