SecondValue Property

Microsoft Office Visual Basic

Returns an optional second value property test (as in a range) for the 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 constant msoConditionAnyTimeBetween or msoConditionAnyNumberBetween.

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