Application.SetTPField method (Project)

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

Syntax

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

expression An expression that returns an Application object.

Parameters

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

Boolean

Example

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.