Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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