ActiveX

To create a static text 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 5 (Static Text).
5. Provide the text to display in the cell using the Text or Value property.
6. Specify the horizontal and vertical text alignment by setting the TypeHAlign and TypeVAlign properties.
7. Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
8. If you want to underline a character in the text, set the TypeTextPrefix property to True and when you provide the text for the cell, type an ampersand (&) in front of the character you want to underline.
9. Specify that text wraps in the cell if the text string is wider than the cell width by setting the TypeTextWordWrap property to True.
10. Specify the color of the text in the cell by setting the ShadowText property.
11. Specify the background color of the cell by setting the ShadowColor property.
12. If you selected a block of cells, set the BlockMode property back to False.