Assignment object (Project)

Represents an assignment for a task or resource. The Assignment object is a member of an Assignments or an OverAllocatedAssignments collection.

Example

Using the Assignment Object

Use Assignments (index), where index is the assignment index number, to return a single Assignment object. The following example displays the name of the first resource assigned to the specified task.

MsgBox ActiveProject.Tasks(1).Assignments(1).ResourceName

Using the Assignments Collection

Use the Assignments property to return an Assignments collection. The following example displays all the resources assigned to the specified task.

Dim A As Assignment 
 
For Each A In ActiveProject.Tasks(1).Assignments 
 MsgBox A.ResourceName 
Next A

Use the Add method to add an Assignment object to the Assignments collection. The following example adds a resource identified by the number 212 as a new assignment for the specified task.

ActiveProject.Tasks(1).Assignments.Add ResourceID:=212

Methods

Properties

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.