ActiveX

To display pictures in 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 TypeCheckPicture property using the following index values to specify which picture you are setting for each state:

   Index Value	Sets picture displayed for this state
   0 - Unchecked	False
   1 - Checked	True
   2 - Unchecked pressed	False pressed
   3 - Checked pressed	True pressed
   4 - Grayed	Grayed
   5 - Grayed pressed	Grayed pressed

6. Specify where the text is displayed in relation to the picture by setting the TypeCheckTextAlign property.
7. If you selected a block of cells, set the BlockMode property back to False.