ActiveX

To display text 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 TypeButtonText property to specify the text to display in the button cell.
6. Set the TypeButtonAlign property to specify how to align the text in the button cell.
   If you are also displaying a picture in the button cell, 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.
7. If you selected a block of cells, set the BlockMode property back to False.