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

Resource.Overallocated Property (Project)

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

True if a resource is overallocated. Read-only Boolean.


expression. Overallocated

expression A variable that represents a Resource object.


The Overallocated property does not return any meaningful information for material resources.


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