Table of contents
Collapse the table of content
Expand the table of content

Task.Overallocated Property (Project)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

True if any of the assignments for a task is overallocated. Read-only Boolean.


expression. Overallocated

expression A variable that represents a Task object.


The following example displays the percentage of resources in the active project that are overallocated.

Sub DisplayOverallocatedPercentage() 

 Dim R As Resource ' Resource object used in For Each loop 
 Dim NOverallocated As Long ' Number of overallocated resources 

 For Each R In ActiveProject.Resources 
 If R.Overallocated Then NOverallocated = NOverallocated + 1 
 Next R 

 MsgBox (Str$((NOverallocated / ActiveProject.Resources.Count) * 100) _ 
 &; " percent (" &; Str$(NOverallocated) &; "/" &; Str$(ActiveProject.Resources.Count) _ 
 &; ")" &; " of the resources in this project are overallocated.") 

End Sub
© 2018 Microsoft