ActiveX
To create a picture 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 9 (Picture).
- Specify the picture to display by setting the TypePictPicture property.
-
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.
- Specify the horizontal and vertical picture alignment in the cell by setting the TypeHAlign and TypeVAlign properties.
- If you selected a block of cells, set the BlockMode property back to False.