Change a FlexGrid Row Back Color

[ComITSolutions]

The method above will work just fine but it will be faster if you select the cells abd then change the color of the selection.

I Agree DataMiser, the same code can be modified as below:

Private Sub SetBackColor(FlexGrid As MSHFlexGrid, RowNo As Integer, BkColor As ColorConstants)
    With FlexGrid
        If RowNo >= .Rows Then
            MsgBox "Invalid RowNo"
        End If
        .FillStyle = flexFillRepeat '<----Without this line it will not work
        
        .Row = RowNo
        .Col = .FixedCols
        
        .RowSel = RowNo
        .ColSel = .Cols - 1
        
        .CellBackColor = BkColor
    End With
End Sub