ActiveX

To create a check box cell and set its type

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. Specify the horizontal and vertical alignment of the check box and text with the TypeHAlign and TypeVAlign properties.
   If you want to center the check box and text horizontally and vertically in the cell, perform one of the following actions:
   • Set the TypeCheckCenter property to True.
   • Set the TypeHAlign and TypeVAlign properties to 2 (Center) and 2 (VCenter), respectively.
6. If you want to provide a three-state check box, set the TypeCheckType property to 1 (Three-state).
7. If you selected a block of cells, set the BlockMode property back to False.