ActiveX
To display three-dimensional effects in 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 a three-dimensional appearance by doing one of the following:
- If you want the cell to display a raised three-dimensional appearance, set the TypeTextShadow property to True.
-
If you want the cell to display a lowered three-dimensional appearance, set the TypeTextShadowIn property to True.
Note: If you set both the TypeTextShadow and TypeTextShadowIn properties to True, the cell displays a raised shadow effect as specified by the TypeTextShadow property.
- To set the color of the shadow in the three-dimensional appearance, set the ShadowDark property.
- If you selected a block of cells, set the BlockMode property back to False.