ActiveX

To display an ellipsis in a cell

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 for the type of cell.
5. Allow the cell to display the ellipsis for long text by setting the TypeEllipses property to True.
6. If you set the CellType property to 12 (Currency), 13 (Number), or 14 (Percent) in step 3, set the TypeHAlign property to 0 (Left).
7. If you selected a block of cells, set the BlockMode property back to False.