GroupCriteria2.Add method (Project)
Adds a GroupCriterion2 object to the GroupCriteria2 collection.
Syntax
expression.Add (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 | PjColor | The color of the font in a group definition. Can be one of the PjColor constants. The default value is pjBlack. |
| CellColor | Optional | PjColor | The color of the cell background in a group definition. Can be one of the PjColor constants. The default value is pjColorAutomatic. |
| 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
To add a GroupCriterion2 object where colors can be hexadecimal values, use the AddEx method.
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.