Specifies the cell's sort data.
Type | Description | |||
Item as Variant | A long expression that indicates the item's handle | |||
ColIndex as Variant | A long expression that indicates the cell's handle or the column's index, a string expression that indicates the column's caption or the column's key. | |||
Variant | A long expression that indicates the cell's sort data. |
The CellSortData property specifies the value being sorted if the SortType property is SortCellData or SortCellDataString. Use the CellData property to associate an extra data to a cell. Use the CellValue property to specify the cell's value. Use the CellCaption property to get the string being displayed in the cell.
Note: The intersection of an item with a column defines a cell. Each cell is uniquely represented by its handle. The cell's handle is of HCELL type, that's equivalent with a long type. All properties of Items object that have two parameters Item and ColIndex, refer a cell.
The following lines are equivalents and each of them changes the bold font attribute of the first cell on the first item.
With Grid1 .Items.CellBold(, .Items.ItemCell(.Items(0), 0)) = True .Items.CellBold(.Items(0), 0) = True .Items.CellBold(.Items(0)) = True .Items.CellBold(.Items.ItemByIndex(0)) = True .Items.CellBold(.Items.ItemByIndex(0), 0) = True .Items.CellBold(.Items(0), Grid1.Columns(0).Caption) = True End With