ActiveX
To specify the text for a check box cell
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Set the Col, Col2, Row, and Row2 properties as appropriate.
- If you are selecting a block of cells, set the BlockMode property to True.
- Set the CellType property to 10 (Check Box).
- Set the TypeCheckText property to specify the text to display in the cell.
- 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).
- If you selected a block of cells, set the BlockMode property back to False.