ActiveX

To specify the text for a check box cell

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the Col, Col2, Row, and Row2 properties as appropriate.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Set the CellType property to 10 (Check Box).
5. Set the TypeCheckText property to specify the text to display in the cell.
6. If you want to display the text to the left of the check box or the picture in the cell, set the TypeCheckTextAlign property to 0 (Left).
7. If you selected a block of cells, set the BlockMode property back to False.