Condition Property

Applies To

PropertyTest object.

Description

Returns the condition of the specified search criteria. Read-only Variant.

Can be one of the following MsoCondition constants:

  • msoConditionAnyNumberBetween
  • msoConditionAnytime
  • msoConditionAnytimeBetween
  • msoConditionAtLeast
  • msoConditionAtMost
  • msoConditionBeginsWith
  • msoConditionDoesNotEqual
  • msoConditionEndsWith
  • msoConditionEquals
  • msoConditionFileTypeAllFiles
  • msoConditionFileTypeBinders
  • msoConditionFileTypeDatabases
  • msoConditionFileTypeExcelWorkbooks
  • msoConditionFileTypeOfficeFiles
  • msoConditionFileTypePowerPointPresentations
  • msoConditionFileTypeTemplates
  • msoConditionFileTypeWordDocuments
  • msoConditionIncludesNearEachOther
  • msoConditionIncludesPhrase
  • msoConditionInTheLast
  • msoConditionInTheNext
  • msoConditionIsExactly
  • msoConditionIsNo
  • msoConditionIsNot
  • msoConditionIsYes
  • msoConditionLastMonth
  • msoConditionLastWeek
  • msoConditionLessThan
  • msoConditionMoreThan
  • msoConditionNextMonth
  • msoConditionNextWeek
  • msoConditionOn
  • msoConditionOnorAfter
  • msoConditionOnorBefore
  • msoConditionThisMonth
  • msoConditionThisWeek
  • msoConditionToday
  • msoConditionTomorrow
  • msoConditionYesterday

See Also

NewSearch method.

Example

This example returns the connection value for search criteria for the first property test.

With Application.FileSearch.PropertyTests(1)
    MsgBox "The condition you've set is: " & .Condition
End With