Share via

Application.ProjectBeforeAssignmentChange Event

  • Article
Project Developer Reference

Occurs before the user changes the value of an assignment field.

Syntax

expression.ProjectBeforeAssignmentChange(asg, Field, NewVal, Cancel)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
asg Required Assignment The assignment whose field is being changed.
Field Required PjAssignmentField The field being changed. If more than one field is changed by the user, the event is fired for each field changed. Can be one of the following PjAssignmentField constants.
NewVal Required Variant The new value for the field specified with Field.
Cancel Required Boolean False when the event occurs. If the event procedure sets this argument to True, the value for the field specified with Field is not changed.

Remarks
Microsoft Office Project 2007 events do not occur when the project is embedded in another document or application.

The ProjectBeforeAssignmentChange event doesn't occur when timescaled data changes, when an entire resource or task row is pasted, when an assignment is changed as the result of a drag-and-drop operation in the Resource Usage view, during resource pool operations, when inserting or removing a subproject, or when changes have been made using a custom form. For more information and sample code for creating and testing an event handler, see Using Events with Application and Project Objects.

Example
This example examines any new resource assignments and cancels them if they are for the specified resource. This example requires a new class module and additional code for it to have an effect.

Visual Basic for Applications 
  Private Sub App_ProjectBeforeAssignmentChange(ByVal asg As Assignment, ByVal Field As PjAssignmentField, _
    ByVal NewVal As Variant, Cancel As Boolean)

If Field = pjAssignmentResourceName And NewVal = "Lisa Jones" Then
    MsgBox "Lisa is no longer available for assignment!"
    Cancel = True
End If



End Sub

See Also