ActiveX

To display a picture in a button 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.
   For more information about setting the Col and Row properties, see Using Column and Row Properties.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Set the CellType property to 7 (Button).
5. Set the TypeButtonPicture property to specify the picture to display when the button is not pressed ("up" or False).
6. Set the TypeButtonPictureDown property to specify the picture to display when the button is pressed ("down" or True).
7. Set the TypeButtonAlign property to specify the alignment for the picture in relation to button text.
   The text alignment setting moves the text to whichever side of the picture you specify. For example, if you set the position of the text to be on the left, the button cell displays the text on the left and the picture on the right. If the button cell does not display text, the setting of the TypeButtonAlign property has no effect, and the control centers the picture in the cell.
8. If you selected a block of cells, set the BlockMode property back to False.