Class ModelFormatPercentageNumber (Excel VBA)

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

Item

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.

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