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

Application.FindEx Method (Project)

office 365 dev account|Last Updated: 10/19/2017
2 Contributors

Searches for an unfiltered value in a specified field or in all available fields; returns True if the value is found.


expression. FindEx (Field, Test, Value, Next, MatchCase, FieldID, TestID, SearchAllFields)

expression An expression that returns an Application object.


NameRequired/OptionalData TypeDescription
FieldOptionalStringThe name of the field to search.
TestOptionalStringThe type of comparison made between Field and Value. Can be one of the following comparison strings.
ValueOptionalStringThe value to compare with the field specified by Field.
NextOptionalBooleanTrue if Project searches down for the next occurrence of a value that matches the search criteria. False if Project searches up for the next occurrence. The default value is True.
MatchCaseOptionalBooleanTrue if the search is case-sensitive. The default value is False.
FieldIDOptionalVariantThe field identification number can be one of the PjField constants. FieldID takes precedence over any Field value.
TestIDOptionalVariantThe test identification number can be one of the PjComparison constants. TestID takes precedence over any Test value.
SearchAllFieldsOptionalBooleanIf True, search for the specified value in all available fields. The default value is False.

Comparison strings

Comparison stringDescription
"equals"The value of Field equals Value.
"does not equal"The value of Field does not equal Value.
"is greater than"The value of Field is greater than Value.
"is greater than or equal to"The value of Field is greater than or equal to Value.
"is less than"The value of Field is less than Value.
"is less than or equal to"The value of Field is less than or equal to Value.
"is within"The value of Field is within Value.
"is not within"The value of Field is not within Value.
"contains"Field contains Value.
"does not contain"Field does not contain Value.
"contains exactly"Field contains exactly Value.

Return value



Using the FindEx method with no arguments, or without specifying Field, Test, and Value, displays the Find dialog box that has options set for the previous state. If you set SearchAllFields to True, programmatic use still requires values for the Field, Test, and Value parameters.


Either of the following statements finds the next field that contains the value 2, within the set of all available fields.

FindEx Field:="Name", value:="2", Test:="contains", SearchAllFields:=True 
FindEx Field:="OtherField", value:="2", Test:="xx", FieldID:=pjTaskName, _
    TestID:=pjCompareContains, SearchAllFields:=True
© 2018 Microsoft