Class ModelFormatCurrency (Excel VBA)

The class ModelFormatCurrency represents the format to be used for a model measure in the data model.

Item

To use a ModelFormatCurrency class variable it first needs to be instantiated, for example

Dim mfc as ModelFormatCurrency
Set mfc = ActiveWorkbook.Model.ModelFormatCurrency

ModelFormatCurrency class variables can be set using the Model.ModelFormatCurrency procedure.

DecimalPlaces

Specifies the number of decimal places after the dot.

ActiveWorkbook.Model.ModelFormatCurrency.DecimalPlaces =

Symbol

Specifies the symbol to use to represent the currency.

ActiveWorkbook.Model.ModelFormatCurrency.Symbol =