Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DataListxf_DataListDataList Base Class
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
StartRow as Long
The row at which to start the search.
EndRow as Long
The row at which to end the search, or -1 for the last row in the DataList.
FieldAndValList as Variant
The list of paired values, column name or index then value, passed as a variant
Call Template:
Dim obj As New xf_DataList
Dim i As Long
i = obj.FindValueInRange_VPA(StartRow, EndRow, FieldAndValList)
See Also:
Example 1:
Debug.Print FindValueInRange_VPA(12, 30, "CategoryID", 2, "UnitPrice", 10) -> 3