ActiveX

To format 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. If you want to hide the currency symbol, set the TypeCurrencyShowSymbol property to False.
6. If you want to specify a custom currency symbol, provide the symbol using the TypeCurrencySymbol property.
7. If you want to specify a custom separator character, provide the character using the TypeCurrencySeparator property.
   You must set the TypeCurrencyShowSep property to True to display a separator character.
8. If you want to specify a custom decimal symbol, provide the symbol using the TypeCurrencyDecimal property.
9. If you want to specify whether a leading zero is displayed for values between 1.0 and –1.0, set the TypeCurrencyLeadingZero property.
10. If you want to specify a different format for positive values, set the TypeCurrencyPosStyle property.
11. If you want to specify a different format for negative values, set the TypeCurrencyNegStyle property.
12. If you selected a block of cells, set the BlockMode property back to False.