ActiveX
To create a static text 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 5 (Static Text).
- Provide the text to display in the cell using the Text or Value property.
- Specify the horizontal and vertical text alignment by setting the TypeHAlign and TypeVAlign properties.
- Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
- 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.
- Specify that text wraps in the cell if the text string is wider than the cell width by setting the TypeTextWordWrap property to True.
- Specify the color of the text in the cell by setting the ShadowText property.
- Specify the background color of the cell by setting the ShadowColor property.
- If you selected a block of cells, set the BlockMode property back to False.