Function List Class

Lookup

Return True if the value vValue exists in the List . Function returns False otherwise.

Signature (Visual Basic / VBA)

Public Function Lookup( _
      ByVal vValue As Variant _
    , Optional ByVal vCompare As Variant _
    ) As Boolean

Code Example

    Assuming
       Dim lstTemp As New List
       lstTemp.Add "FunctionName"
       lstTemp.Add "SubName"
    for example
       lstTemp.Lookup("SubName") = True

Parameters

Parameter Description
vValue The Value that will be searched for within the List . vValue can be any type of Variant value on which comparisons can be made using the EqualLikeDataTypeFast function (vbString, numeric, vbDate, etc.).
vCompare Specifies the type of string comparison used to determine if Names match. vCompare defaults to the value of the Compare Property if it is missing.

Notes & Version History

v2.0 Change Changed the vCompare argument so that it can no longer be Null or non-numeric. It is still Optional though, so it can be missing.
v1.1 BugFix Fixed a bug in this function that caused it to not work in all cases.