GroupCriteria2.AddEx method (Project)
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.