ColData, RowData, BandData Properties (MSHFlexGrid)

       

Returns or sets an arbitrary long value associated with each row, column, or band. These properties are not available at design time.

Syntax

object.ColData(number) [=value]
object.RowData(number) [=value]
object.BandData(number) [=value]

Syntax for the ColData, RowData, and BandData properties has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
number A Long value that specifies the column, row, or band in the MSHFlexGrid. This number indicates where to save or retrieve the data.
value A Long value that specifies the contents of the ColData, RowData, or BandData arrays.

Remarks

Use the RowData, ColData, and BandData properties to associate a specific number with each row, column, or band on an MSHFlexGrid. Once a number is associated with each row, column, or band, you can use the numbers programmatically to identify the items.

You can add rows containing totals to an MSHFlexGrid and identify those rows by setting their RowData property to a non-zero value. To update the totals, you can delete the old totals by scanning the RowData array and removing the appropriate rows.

Another typical use of the RowData property is to keep an index in an array of data structures associated with the items described in each row.