Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DataListxf_DataListDataList Base Class
Public Property Get ItemByIndex (
ColIndex As Integer,
RowIndex As Long,
Optional SuppressError As Boolean = False
) As Variant
Return the data item by column and row index. This accessor does not support column names, iteration or unique value lookup, but it is very fast.
ColIndex as Integer
The column index (1 ... ColCount)
RowIndex as Long
The row index (1 ... RowCount)
Optional SuppressError as Boolean = False
Do not display an error message if the row or column index are out of range, just return Null.
Call Template:
Dim obj As New xf_DataList
Dim v As Variant
v = obj.ItemByIndex(ColIndex, RowIndex)
v = obj.ItemByIndex(ColIndex, RowIndex, SuppressError)
See Also:
Example 1:
Debug.Print lst.ItemByIndex(2, 4) lst.ItemByIndex(2, 4) = "DataTest1"