通过

Application.Find Method

  • 项目
Project Developer Reference

Searches for an unfiltered value and returns True if found.

Syntax

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

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Field Optional String The name of the field to search.
Test Optional String The type of comparison made between Field and Value. Can be one of the following 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.
Comparison string Description
"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.
Value Optional String The value to compare with the value of the field specified with Field.
Next Optional Boolean True if Project searches down for the next occurrence of matching search criteria. False if the program searches up for the next occurrence. The default value is True.
MatchCase Optional Boolean True if the search is case-sensitive. The default value is False.
FieldID Optional Variant
TestID Optional Variant

Return Value
Boolean

Remarks

Using the Find method without specifying any arguments displays the Find dialog box.

Example
The following example finds the next task with highest priority.

Visual Basic for Applications 
  Sub FindFirstID
    Find Field:="Priority", Test:="equals", Value:="Highest"
End Sub

See Also