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

DecimalPlaces

Specifies the number of decimal places after the dot.

ActiveWorkbook.Model.ModelFormatPercentageNumber.DecimalPlaces =

UseThousandSeparator

Specifies whether to display commas between thousands.

ActiveWorkbook.Model.ModelFormatPercentageNumber.UseThousandSeparator = True