Edit

GroupCriteria2.AddEx method (Project)

  • Article

Adds a GroupCriterion2 object to the GroupCriteria2 collection, where CellColor can be a hexadecimal value.

Syntax

expression. AddEx( _FieldName_, _Ascending_, _FontName_, _FontSize_, _FontBold_, _FontItalic_, _FontUnderLine_, _FontColor_, _CellColor_, _Pattern_, _GroupOn_, _StartAt_, _GroupInterval_ )

expression An expression that returns a 'GroupCriteria2' object.

Parameters

Name Required/Optional Data type Description
FieldName Required String The name of the field being grouped by.
Ascending Optional Boolean True if the field in a group definition should be grouped in ascending order. False if the field should be grouped in descending order. The default value is True.
FontName Optional String The name of the font for a group definition.
FontSize Optional [INT] The size of the font in a group definition, in points. The default value is 8.
FontBold Optional Boolean True if the font in a group definition is bold. The default value is True.
FontItalic Optional Boolean True if the font in a group definition is italic. The default value is False.
FontUnderLine Optional Boolean True if the font in a group definition is underlined. The default value is False.
FontColor Optional Long The color of the font in a group definition, where color can be a hexadecimal value. See remarks. The default value is &H0.
CellColor Optional Long The color of the cell background specified by a hexadecimal value. See remarks. The default value is &HFFFFFF.
Pattern Optional PjBackgroundPattern The pattern for the cells in a group definition. Can be one of the PjBackgroundPattern constants.
GroupOn Optional PjGroupOn The type of grouping in a group definition. Can be one of the PjGroupOn constants. The default value is pjGroupOnEachValue.
StartAt Optional Variant The start of the intervals in a group definition. The default value is 0 for all fields except date fields, where it is the string "Project Start Date".
GroupInterval Optional Variant The interval in a group definition. The default value is 1.

Return value

GroupCriterion2

Remarks

RGB colors can be expressed in decimal or hexadecimal values. In Project, red is the last byte of a hexadecimal value. For example, if the value of CellColorEx is 65535, the color is blue (&HFF0000).

The valid range for a normal RGB color is 0 to 16,777,215 (&HFFFFFF&). Each color setting (property or argument) is a 4-byte integer. The high byte of a number in this range equals 0. The lower 3 bytes, from least to most significant byte, determine the amount of red, green, and blue, respectively. The red, green, and blue components are each represented by a number between 0 and 255 (&HFF).

See also

GroupCriteria2 Collection Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.