ActiveX

To create and customize a currency 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 12 (Currency).
5. Specify the maximum value for the cell using the TypeCurrencyMax property.
6. Specify the minimum value for the cell using the TypeCurrencyMin property.
7. Specify the number of decimal digits to display using the TypeCurrencyDecPlaces property.

   Note: The total number of digits to the left and right of the decimal symbol cannot total more than 14.

8. If you want to display a separator character, set the TypeCurrencyShowSep property to True.
9. Specify the horizontal and vertical alignment of the data in the cell by setting the TypeHAlign and TypeVAlign properties.
10. Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
11. If you selected a block of cells, set the BlockMode property back to False.