change color font in entire row in msflexgrid

[sal21]

How to change color font (red) from row 3 to the end of last column in msflexgrid

in my case have 7 column

[HansV]

Do you really mean from row 3? Or from column 3 to column 7?

[sal21]

Do you really mean from row 3? Or from column 3 to column 7?

Yes, from row 3 to the end of column

[HansV]

I cannot test this myself.

Code: Select all

Sub Test()
    Dim r As Long
    Dim c As Long
    With Me.MSFlexGrid1
        For r = 2 To .Rows - 1
            For c = 0 To 6
                .Row = r
                .Col = c
                .CellForeColor = vbRed
            Next c
        Next r
    End With
End Sub