VBFlexGrid Control (Replacement of the MSFlexGrid control)

[Krool]

bincong,

instead of doing .RowHidden(1) = False there is a more elegant solution. (where you see the focus rect when control has focus)
But this works only when you have more than 1 column in the scrollable area. Because then SelChange event is fired. When you have 1 column then .ColSel is always same as .Col and SelChange will not fire in this case.

With VBFlexGrid1
    .SelectRange 1, 1, 1, 1 ' .RowHidden(1) = False
    .SelectionMode = FlexSelectionModeByRow
    .AllowSelection = False
    .AllowMultiSelection = False
End With

This works now because due to latest release .AllowSelection and .AllowMultiSelection will not enforce selection according to selection mode anymore. So that the previous .SelectRange 1, 1, 1, 1 stays intact.