BoxCellEdit Method
Sets the properties for an individual cell in a Network Diagram data template.
Syntax
expression**.BoxCellEdit(Name, Cell, FieldName, Font, FontSize, FontColor, Bold, Italic, Underline, HorizontalAlignment, VerticalAlignment, TextLineLimit, ShowLabel, Label, DateFormat)**
*expression * Optional. An expression that returns an Application object.
Name Required String. The name of the data template containing the cell to edit.
PjCell
Constant | Position |
---|---|
pjCell1_1 | column 1, row 1 |
pjCell1_2 | column 1, row 2 |
pjCell1_3 | column 1, row 3 |
pjCell1_4 | column 1, row 4 |
pjCell2_1 | column 2, row 1 |
pjCell2_2 | column 2, row 2 |
pjCell2_3 | column 2, row 3 |
pjCell2_4 | column 2, row 4 |
pjCell3_1 | column 3, row 1 |
pjCell3_2 | column 3, row 2 |
pjCell3_3 | column 3, row 3 |
pjCell3_4 | column 3, row 4 |
pjCell4_1 | column 4, row 1 |
pjCell4_2 | column 4, row 2 |
pjCell4_3 | column 4, row 3 |
pjCell4_4 | column 4, row 4 |
PjField
pjResourceAccrueAt | pjTaskConfirmed |
pjResourceActualCost | pjTaskConstraintDate |
pjResourceActualOvertimeCost | pjTaskConstraintType |
pjResourceActualOvertimeWork | pjTaskContact |
pjResourceActualOvertimeWorkProtected | pjTaskCost |
pjResourceActualWork | pjTaskCost1-10 |
pjResourceActualWorkProtected | pjTaskCostRateTable |
pjResourceACWP | pjTaskCostVariance |
pjResourceAssignmentDelay | pjTaskCPI |
pjResourceAssignmentUnits | pjTaskCreated |
pjResourceAvailableFrom | pjTaskCritical |
pjResourceAvailableTo | pjTaskCV |
pjResourceBaseCalendar | pjTaskCVPercent |
pjResourceBaseline1-10Cost | pjTaskDate1-10 |
pjResourceBaseline1-10Finish | pjTaskDeadline |
pjResourceBaseline1-10Start | pjTaskDelay |
pjResourceBaseline1-10Work | pjTaskDemandedRequest |
pjResourceBaselineCost | pjTaskDuration |
pjResourceBaselineFinish | pjTaskDuration1-10 |
pjResourceBaselineStart | pjTaskDuration1-10Estimated |
pjResourceBaselineWork | pjTaskDurationVariance |
pjResourceBCWP | pjTaskEAC |
pjResourceBCWS | pjTaskEarlyFinish |
pjResourceBookingType | pjTaskEarlyStart |
pjResourceCanLevel | pjTaskEarnedValueMethod |
pjResourceCode | pjTaskEffortDriven |
pjResourceConfirmed | pjTaskEnterpriseCost1-10 |
pjResourceCost | pjTaskEnterpriseDate1-30 |
pjResourceCost1-10 | pjTaskEnterpriseDuration1-10 |
pjResourceCostPerUse | pjTaskEnterpriseFlag1-20 |
pjResourceCostRateTable | pjTaskEnterpriseNumber1-40 |
pjResourceCostVariance | pjTaskEnterpriseOutlineCode1-30 |
pjResourceCreated | pjTaskEnterpriseProjectCost1-10 |
pjResourceCV | pjTaskEnterpriseProjectDate1-30 |
pjResourceDate1-10 | pjTaskEnterpriseProjectDuration1-10 |
pjResourceDemandedRequested | pjTaskEnterpriseProjectFlag1-20 |
pjResourceDuration1-10 | pjTaskEnterpriseProjectNumber1-40 |
pjResourceEMailAddress | pjTaskEnterpriseProjectOutlineCode1-30 |
pjResourceEnterprise | pjTaskEnterpriseProjectText1-40 |
pjResourceEnterpriseBaseCalendar | pjTaskEnterpriseText1-40 |
pjResourceEnterpriseCheckedOutBy | pjTaskEstimated |
pjResourceEnterpriseCost1-10 | pjTaskExternalTask |
pjResourceEnterpriseDate1-30 | pjTaskFinish |
pjResourceEnterpriseDuration1-10 | pjTaskFinish1-10 |
pjResourceEnterpriseFlag1-20 | pjTaskFinishSlack |
pjResourceEnterpriseGeneric | pjTaskFinishVariance |
pjResourceEnterpriseInactive | pjTaskFixedCost |
pjResourceEnterpriseIsCheckedOut | pjTaskFixedCostAccrual |
pjResourceEnterpriseLastModifiedDate | pjTaskFixedDuration |
pjResourceEnterpriseMultiValue20-29 | pjTaskFlag1-20 |
pjResourceEnterpriseNameUsed | pjTaskFreeSlack |
pjResourceEnterpriseNumber1-40 | pjTaskGroupBySummary |
pjResourceEnterpriseOutlineCode1-29 | pjTaskHideBar |
pjResourceEnterpriseRBS | pjTaskHyperlink |
pjResourceEnterpriseRequiredValues | pjTaskHyperlinkAddress |
pjResourceEnterpriseTeamMember | pjTaskHyperlinkHref |
pjResourceEnterpriseText1-40 | pjTaskHyperlinkScreenTip |
pjResourceEnterpriseUniqueID | pjTaskHyperlinkSubAddress |
pjResourceFinish | pjTaskID |
pjResourceFinish1-10 | pjTaskIgnoreResourceCalendar |
pjResourceFlag1-20 | pjTaskIndex |
pjResourceGroup | pjTaskIndicators |
pjResourceGroupBySummary | pjTaskIsAssignment |
pjResourceHyperlink | pjTaskLateFinish |
pjResourceHyperlinkAddress | pjTaskLateStart |
pjResourceHyperlinkHref | pjTaskLevelAssignments |
pjResourceHyperlinkScreenTip | pjTaskLevelCanSplit |
pjResourceHyperlinkSubAddress | pjTaskLevelDelay |
pjResourceID | pjTaskLinkedFields |
pjResourceIndex | pjTaskMarked |
pjResourceIndicators | pjTaskMilestone |
pjResourceInitials | pjTaskName |
pjResourceIsAssignment | pjTaskNotes |
pjResourceLevelingDelay | pjTaskNumber1-20 |
pjResourceLinkedFields | pjTaskObjects |
pjResourceMaterialLabel | pjTaskOutlineCode1-10 |
pjResourceMaxUnits | pjTaskOutlineLevel |
pjResourceName | pjTaskOutlineNumber |
pjResourceNotes | pjTaskOverallocated |
pjResourceNumber1-20 | pjTaskOvertimeCost |
pjResourceObjects | pjTaskOvertimeWork |
pjResourceOutlineCode1-10 | pjTaskParentTask |
pjResourceOverallocated | pjTaskPercentComplete |
pjResourceOvertimeCost | pjTaskPercentWorkComplete |
pjResourceOvertimeRate | pjTaskPhysicalPercentComplete |
pjResourceOvertimeWork | pjTaskPredecessors |
pjResourcePeakUnits | pjTaskPreleveledFinish |
pjResourcePercentWorkComplete | pjTaskPreleveledStart |
pjResourcePhonetics | pjTaskPriority |
pjResourceProject | pjTaskProject |
pjResourceRegularWork | pjTaskRecurring |
pjResourceRemainingCost | pjTaskRegularWork |
pjResourceRemainingOvertimeCost | pjTaskRemainingCost |
pjResourceRemainingOvertimeWork | pjTaskRemainingDuration |
pjResourceRemainingWork | pjTaskRemainingOvertimeCost |
pjResourceResponsePending | pjTaskRemainingOvertimeWork |
pjResourceSheetNotes | pjTaskRemainingWork |
pjResourceStandardRate | pjTaskResourceEnterpriseMultiValueCode20-29 |
pjResourceStart | pjTaskResourceEnterpriseOutlineCode1-29 |
pjResourceStart1-10 | pjTaskResourceEnterpriseRBS |
pjResourceSV | pjTaskResourceGroup |
pjResourceTaskSummaryName | pjTaskResourceInitials |
pjResourceTeamStatusPending | pjTaskResourceNames |
pjResourceText1-30 | pjTaskResourcePhonetics |
pjResourceType | pjTaskResourceType |
pjResourceUniqueID | pjTaskResponsePending |
pjResourceUpdateNeeded | pjTaskResume |
pjResourceVAC | pjTaskResumeNoEarlierThan |
pjResourceWindowsUserAccount | pjTaskRollup |
pjResourceWork | pjTaskSheetNotes |
pjResourceWorkContour | pjTaskSPI |
pjResourceWorkgroup | pjTaskStart |
pjResourceWorkVariance | pjTaskStart1-10 |
pjTaskActualCost | pjTaskStartSlack |
pjTaskActualDuration | pjTaskStartVariance |
pjTaskActualFinish | pjTaskStatus |
pjTaskActualOvertimeCost | pjTaskStatusIndicator |
pjTaskActualOvertimeWork | pjTaskStop |
pjTaskActualOvertimeWorkProtected | pjTaskSubproject |
pjTaskActualStart | pjTaskSubprojectReadOnly |
pjTaskActualWork | pjTaskSuccessors |
pjTaskActualWorkProtected | pjTaskSummary |
pjTaskACWP | pjTaskSV |
pjTaskAssignmentDelay | pjTaskSVPercent |
pjTaskAssignmentUnits | pjTaskTCPI |
pjTaskBaseline1-10Cost | pjTaskTeamStatusPending |
pjTaskBaseline1-10Duration | pjTaskText1-30 |
pjTaskBaseline1-10DurationEstimated | pjTaskTotalSlack |
pjTaskBaseline1-10Finish | pjTaskType |
pjTaskBaseline1-10Start | pjTaskUniqueID |
pjTaskBaseline1-10Work | pjTaskUniquePredecessors |
pjTaskBaselineCost | pjTaskUniqueSuccessors |
pjTaskBaselineDuration | pjTaskUpdateNeeded |
pjTaskBaselineDurationEstimated | pjTaskVAC |
pjTaskBaselineFinish | pjTaskWBS |
pjTaskBaselineStart | pjTaskWBSPredecessors |
pjTaskBaselineWork | pjTaskWBSSuccessors |
pjTaskBCWP | pjTaskWork |
pjTaskBCWS | pjTaskWorkContour |
pjTaskCalendar | pjTaskWorkVariance |
Font Optional String. The name of the font.
FontSize Optional Integer. The size of the font, in points.
PjColor
pjColorAutomatic | pjNavy |
pjAqua | pjOlive |
pjBlack | pjPurple |
pjBlue | pjRed |
pjFuchsia | pjSilver |
pjGray | pjTeal |
pjGreen | pjYellow |
pjLime | pjWhite |
pjMaroon |
Bold Optional Boolean. True if the font is bold.
Italic Optional Boolean. True if the font is italic.
Underline Optional Boolean. True if the font is underlined.
HorizontalAlignment Optional Long. Specifies the horizontal alignment of text in the cell. Can be one of the following PjAlignment constants: pjLeft, pjCenter, or pjRight.
VerticalAlignment Optional Long. Specifies the vertical alignment of text in the cell. Can be one of the following PjVerticalAlignment constants: pjTop, pjMiddle, or pjBottom.
TextLineLimit Optional Long. A value from 1 through 3 that specifies the maximum number of lines of text allowed in the cell.
ShowLabel Optional Boolean. True if a label should display before the field data in the cell.
Label Optional String. The label to display before the field data in the cell when ShowLabel is True.
PjDateFormat
Constant |
Date format applied to 9/30/02 (12:33 PM) |
---|---|
pjDateDefault | The default format, as specified on the View tab of the Options dialog box. |
pjDate_mm_dd_yy_hh_mmAM | 9/30/02 12:33 PM |
pjDate_mm_dd_yy | 9/30/02 |
pjDate_mm_dd_yyyy | 9/30/2002 |
pjDate_mmmm_dd_yyyy_hh_mmAM | September 30, 2002 12:33 PM |
pjDate_mmmm_dd_yyyy | September 30, 2002 |
pjDate_mmm_dd_hh_mmAM | Sep 30 12:33 PM |
pjDate_mmm_dd_yyy | Sep 30, '02 |
pjDate_mmmm_dd | September 30 |
pjDate_mmm_dd | Sep 30 |
pjDate_ddd_mm_dd_yy_hh_mmAM | Mon 9/30/02 12:33 PM |
pjDate_ddd_mm_dd_yy | Mon 9/30/02 |
pjDate_ddd_mmm_dd_yyy | Mon Sep 30, '02 |
pjDate_ddd_hh_mmAM | Mon 12:33 PM |
pjDate_mm_dd | 9/30 |
pjDate_dd | 30 |
pjDate_hh_mmAM | 12:33 PM |
pjDate_ddd_mmm_dd | Mon Sep 30 |
pjDate_ddd_mm_dd | Mon 9/30 |
pjDate_ddd_dd | Mon 30 |
pjDate_Www_dd | W40/1 |
pjDate_Www_dd_yy_hh_mmAM | W40/1/02 12:33 PM |
Remarks
Using the BoxCellEdit method with only the Name and Cell arguments specified has no effect.
Example
This example modifies the specified template to include an additional row listing the assigned resources.
Sub AddNewRowCell()
Application.BoxCellLayout Name:="Microsoft Project 98 upgrade template", CellRows:=4, MergeCells:=True
Application.BoxCellEdit Name:="Microsoft Project 98 upgrade template", Cell:=pjCell1_4, _
FieldName:=pjTaskResourceNames, Font:="Arial", FontSize:="8", FontColor:=pjColorAutomatic, Bold:=False, _
Italic:=False, Underline:=False, HorizontalAlignment:=pjLeft, VerticalAlignment:=pjMiddle, _
TextLineLimit:=1, ShowLabel:=False
End Sub
Applies to | Application Object
See Also | BoxCellLayout Method | BoxStylesEdit Method