Class ModelFormatWholeNumber (Excel VBA)

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

Item

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

Dim mfw as ModelFormatWholeNumber
Set mfw = ActiveWorkbook.Model.ModelFormatWholeNumber

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

UseThousandSeparator

Specifies whether to display commas between thousands.

ActiveWorkbook.Model.ModelFormatWholeNumber.UseThousandSeparator = True