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