Visual Basic: MSFlexGrid/MSHFlexGrid Controls

Visual Studio 6.0

FixedCols, FixedRows Properties (MSHFlexGrid)

See Also    Example    Applies To

  • FixedCols Returns or sets the total number of fixed columns within an MSHFlexGrid.

  • FixedRows Returns or sets the total number of fixed rows within an MSHFlexGrid.

By default, MSHFlexGrid has one fixed column and one fixed row.


object.FixedCols [= value]
object.FixedRows [= value]

Syntax for the FixedCols and FixedRows properties has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A Long value that specifies the total number of fixed columns or fixed rows.


Fixed columns and rows are constant when you scroll other columns or rows in the MSHFlexGrid. You can specify zero or multiple fixed columns rows. In addition, you can select the colors, font, gridline, and text style of the fixed columns and rows.

If the SelectionMode property is a numerical value, when you select a fixed row or fixed column at run time, all cells within that row or column are selected.

If the AllowUserResizing property is a numerical value, you can resize the fixed rows or fixed columns at run time.

Fixed columns and fixed rows are used in spreadsheet applications to display row numbers and column names or letters.