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. |