xf_DataList
xf_DataListPublic Function FindValue(ParamArray FieldAndValList()) As Long
Return the index of the first row where the column values match the passed list, or -1 if the values are not found
Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataListDataList Base Class
Ad-hoc Value Location
Public Function FindValueInRange(StartRow As Long, EndRow As Long, ParamArray FieldAndValList()) As Long
Like FindValue() but search only in the specified range of rows.
Public Function FindValueInRange_VPA(StartRow As Long, EndRow As Long, FieldAndValList As Variant) As Long
Like FindValue() but search only in the specified range of rows and pass an array as a variant rather than a paramarray