Highlighting a search row in a MSHFlexGrid

Hi,
I am trying to assign a record found in a recordset to a MShFlexGrid so that it can display the entire row when a name is seached. I am finding difficulties to assign the property of the MSHFlexGrid that will highlight the row. Here is the code I am using. Any help would be much appreciated. Thanks

Albert

If rsData.EOF Then
MsgBox "Couldn't find the Name"
Else

MSHFlexGrid1. = rsData.Fields.("Lastname").Value

End If

Hi Albert

Code:

---

    Dim i As Integer
   
    With MSFlexGrid1
       
        .Col = 0
        .Row = 2    'assuming we found match in row 2
       
        For i = 0 To .Cols - 1
            .ColSel = i
        Next i
    End With

---