Application.SetTPField method (Project)

Sets a value for the percent complete field of one or more tasks in the Team Planner view.


expression. SetTPField( _Field_, _Value_, _AllSelectedTasks_, _Create_, _TaskID_, _ProjectName_ )

expression An expression that returns an Application object.


Name Required/Optional Data type Description
Field Required String The Field argument can be only "% Complete". You can also use the FieldConstantToFieldName method with pjTaskPercentComplete, as in the example.
Value Required String Value of the Field argument. Values can range from "0" to "100" for percent complete.
AllSelectedTasks Optional Boolean Not used in Project. The value is True, which means that the Field and Value arguments are set for all selected tasks.
Create Optional Boolean Not used in Project.
TaskID Optional Long Not used in Project.
ProjectName Optional String Not used in Project.

Return value



The following example sets the selected tasks in the Team Planner view to 40% complete.

Sub TestSetTPField() 
    Dim fieldName As String 
    fieldName = FieldConstantToFieldName(pjTaskPercentComplete) 
    Application.SetTPField Field:=fieldName, Value:="40" 
End Sub

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.