ActiveX

To create a picture 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 9 (Picture).
5. Specify the picture to display by setting the TypePictPicture property.
6. Specify how the picture is displayed in the cell by doing one or more of the following items:
   • If you want to center the picture in the cell, set the TypePictCenter property to True.
   • If you want to stretch the picture to fit the size of the cell, set the TypePictStretch property to True.
   • If you have stretched the picture to fit the size of the cell, but you want to maintain the picture's proportions, set the TypePictMaintainScale property to True.
7. Specify the horizontal and vertical picture alignment in the cell by setting the TypeHAlign and TypeVAlign properties.
8. If you selected a block of cells, set the BlockMode property back to False.