ActiveX

---

To return unformatted data

You can return unformatted 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	ClipValue	Block of data
	Value	Data for cell, column, row, or sheet as specified using Col and Row properties
Currency, Number, Percent	ClipValue	Block of data
	Value	Data for cell, column, row, or sheet as specified using Col and Row properties
	GetFloat, GetInteger, or GetText	Data for cell, column, row, or sheet as specified using Col and Row parameters

Note: For the Value property and the GetFloat, GetInteger, and GetText methods, 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 these methods 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 methods will not return a value.