Edit

Application.UsageViewEntryEx method (Project)

  • Article

Adds fields to the Details pane and option menu for the Task Usage or Resource Usage views, and formats the styles to help distinguish detail rows.

Syntax

expression. UsageViewEntryEx( _CurIndex_, _Order_, _FontWord_, _CellBackground_, _Pattern_, _Shortcut_, _DisplayField_, _FontColor_ )

expression An expression that returns an Application object.

Parameters

Name Required/Optional Data type Description
CurIndex Optional Integer Current zero-based index of fields in the Show these fields list in the Detail Styles dialog box. Values greater than the number of fields currently shown are reduced to the next highest value in the actual list. For example, if there are two fields showing and CurIndex = 8, the value of CurIndex is reduced to 2. The default value is 0.
Order Optional Integer Order of the field in an internal array of fields. For valid values, see the table of field names in the Remarks section.
FontWord Optional Long Deprecated in Project. In some versions of Project, FontWord set the font color by using the PjColor enumeration.
CellBackground Optional Long Color of the cells for entry. Can be a hexadecimal RGB value, where red is the last byte. For example, &HFFFF00 is blue-green.
Pattern Optional Integer Background pattern of the cells for entry. Can be one of the PjBackgroundPattern constants.
Shortcut Optional Boolean True if the field is shown on the option menu of the Details pane; otherwise, False. Shortcut is True if DisplayField is True.
DisplayField Optional Boolean True if the field is displayed in the Details pane; otherwise, False. The DisplayField parameter has no effect on fields that are already displayed.
FontColor Optional Long Color of text in the Details column for usage entry. Can be a hexadecimal RGB value, where red is the last byte. For example, &HFF00FF is purple.

Return value

Boolean

Remarks

In the Task Usage or Resource Usage view, choose the FORMAT tab to see the six default fields in the Details group on the ribbon. The Add Details command displays the Detail Styles dialog box, which shows—in alphabetical order—all of the fields available in the current view.

The following table lists the possible fields for the Order parameter, and shows values for the Task Usage and Resource Usage views.

Field name for the Order parameter Task Usage Value Resource Usage Value
Work 0 0
Overtime Work 1 1
Actual Work 2 2
Actual Overtime Work 3 3
Cumulative Work 4 4
Baseline Work 5 5
Overallocation 6 6
Percent Allocation 7 7
Peak Units 8 8
Cost 9 9
Fixed Cost 10 N/A
Actual Cost 11 10
Baseline Cost 12 11
Cumulative Cost 13 12
BCWS 14 13
BCWP 15 14
ACWP 16 15
SV 17 16
CV 18 17
Regular Work 19 18
Remaining Availability N/A 19
Unit Availability N/A 20
Work Availability N/A 21
Percent Complete 20 N/A
Cumulative Percent Complete 21 N/A
Baseline 1 Work 22 22
Baseline 1 Cost 23 23
Baseline 2 Work 24 24
Baseline 2 Cost 25 25
Baseline 3 Work 26 26
Baseline 3 Cost 27 27
Baseline 4 Work 28 28
Baseline 4 Cost 29 29
Baseline 5 Work 30 30
Baseline 5 Cost 31 31
Baseline 6 Work 32 32
Baseline 6 Cost 33 33
Baseline 7 Work 34 34
Baseline 7 Cost 35 35
Baseline 8 Work 36 36
Baseline 8 Cost 37 37
Baseline 9 Work 38 38
Baseline 9 Cost 39 39
Baseline 10 Work 40 40
Baseline 10 Cost 41 41
Actual Fixed Cost 42 N/A
CPI 43 N/A
SPI 44 N/A
CV Percent 45 N/A
SV Percent 46 N/A
Budget Work 47 42
Budget Cost 48 43
Baseline Budget Work 49 44
Baseline Budget Cost 50 45
Baseline 1 Budget Work 51 46
Baseline 1 Budget Cost 52 47
Baseline 2 Budget Work 53 48
Baseline 2 Budget Cost 54 49
Baseline 3 Budget Work 55 50
Baseline 3 Budget Cost 56 51
Baseline 4 Budget Work 57 52
Baseline 4 Budget Cost 58 53
Baseline 5 Budget Work 59 54
Baseline 5 Budget Cost 60 55
Baseline 6 Budget Work 61 56
Baseline 6 Budget Cost 62 57
Baseline 7 Budget Work 63 58
Baseline 7 Budget Cost 64 59
Baseline 8 Budget Work 65 60
Baseline 8 Budget Cost 66 61
Baseline 9 Budget Work 67 62
Baseline 9 Budget Cost 68 63
Baseline 10 Budget Work 69 64
Baseline 10 Budget Cost 70 65
All Task Rows 71 N/A
All Resource Rows N/A 66
All Assignment Rows 72 67

In Project 2003 and Office Project 2007, the original UsageViewEntry method was not exposed in the VBA object model.

Example

In the Resource Usage view, the following statement colors the cells for data entry a light yellow in a diagonal-left pattern and colors the Work text in the Details column purple to help show the rows for data entry.

Application.UsageViewEntryEx CellBackground:=&H01ffff, Pattern:=pjBackgroundDiagonalLeft, _ 
 FontColor:=&Hff00ff

In the Task Usage view, the default field is Work. The following statement adds the Actual Cost field in green, after the Work field.

Application.UsageViewEntryEx Order:=11, CurIndex:=1, DisplayField:=True, FontColor:=&H10FF10

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.