GroupCriteria.Add method (Project)
Adds a GroupCriterion object to a GroupCriteria collection.
Syntax
expression.Add (FieldName, Ascending, FontName, FontSize, FontBold, FontItalic, FontUnderLine, FontColor, CellColor, Pattern, GroupOn, StartAt, GroupInterval)
expression A variable that represents a 'GroupCriteria' 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 | Integer | 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. Can be one of the PjColor constants. The default value is pjBlack. |
| CellColor | Optional | Long | The color of the cell background in a group definition. Can be one of the PjColor constants. The default value is pjColorAutomatic. |
| Pattern | Optional | Long | The pattern for the cells in a group definition. Can be one of the PjBackgroundPattern constants. |
| GroupOn | Optional | Long | 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
GroupCriterion
See also
GroupCriteria 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.