Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DataListxf_DataListDataList Base Class
Public Function FindValueInRange (
StartRow As Long,
EndRow As Long,
ParamArray FieldAndValList()
) As Long
Like FindValue() but search only in the specified range of rows.
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.
ParamArray FieldAndValList() as Variant
The list of paired values, column name or index then value.
Call Template:
Dim obj As New xf_DataList
Dim i As Long
i = obj.FindValueInRange(StartRow, EndRow, FieldAndValList)
See Also:
Example 1:
Debug.Print FindValueInRange(12, 30, "CategoryID", 2, "UnitPrice", 10) -> 3