ActiveX

---

To return formatted data

You can return formatted data using different properties or methods, depending on the data you want to return. For more detailed information about each of these properties and methods, see the property or method topic in the ActiveX Reference.

Cell type	Method or Property	Use to return . . .
Button, Check box, Combo box, Date, Edit, PIC, Static Text, Time	Clip	Block of data
	Text	Data for cell, column, row, or sheet as specified using Col and Row properties
	GetText	Data for cell, column, row, or sheet as specified using Col and Row parameters
Currency, Number, Percent	Clip	Block of data
	Text	Data for cell, column, row, or sheet as specified using Col and Row properties

Note: For the Text property and the GetText method, if you set the data in the sheet by setting the Col or Row property or the Col or Row parameters to –1, this property and method will return the text for the entire column, row, or sheet you specify. If you did not set the data with the Col or Row property or Col or Row parameter set to –1, and then attempt to return data by setting the Col or Row property or the Col or Row parameter to –1, the property or method will not return a value.