ActiveX
To add unformatted data
You can set unformatted data using different properties or methods, depending on the data you have and the cell types you are working with. 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 set . . . |
|---|---|---|
| Button, Check box, Combo box, Date, Edit, PIC, Static Text, Time | ClipValue | Block of data, where tab characters separate columns and carriage return and linefeed characters separate rows |
| Value | Data for cell, column, row, or sheet as specified using Col and Row properties. Sets the same data in each cell if you set multiple cells. | |
| Currency, Number, Percent | ClipValue | Block of data |
| Value | Data for cell, column, row, or sheet as specified using Col and Row properties. Sets the same data in each cell if you set multiple cells. | |
| SetFloat, SetInteger (number cells only), or SetText | Data for cell, column, row, or sheet as specified using Col and Row parameters. Sets the same data in each cell if you set multiple cells. |