SecondValue Property

Applies To

PropertyTest object.

Description

Returns an optional second value property test (as in a range) for the specified file search. Read-only Variant.

Remarks

This property is intended to be used to specify a range, and it can only be used with the MsoCondition constants msoConditionAnyTimeBetween or msoConditionAnyNumberBetween.

See Also

Value property.

Example

This example displays the second value of the search criteria (if it exists) in a dialog box. If the second value doesn't exist, the example displays another message.

With Application.FileSearch.PropertyTests(1)
If .SecondValue = "" Then
    MsgBox "You haven't specified a second value."
Else
    MsgBox "The second value you've set is: " & .SecondValue
End If
End With