Class ModelFormatPercentageNumber (Excel VBA)

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


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

Dim mfp as ModelFormatPercentageNumber
Set mfp = ActiveWorkbook.Model.ModelFormatPercentageNumber

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


Specifies the number of decimal places after the dot.

ActiveWorkbook.Model.ModelFormatPercentageNumber.DecimalPlaces =


Specifies whether to display commas between thousands.

ActiveWorkbook.Model.ModelFormatPercentageNumber.UseThousandSeparator = True