I would like to be able to select a row in my MSHFlexgrid1 and from that specific row, it would search for the value in column 4 into the MSHFlexgrid2 column 1. If there is a perfect match, it would select the MSHFlexgrid2 row and put the column: MSHFlexGrid2.CellBackColor
= &H80FF& in the column 1.
if i select MSHFlexgrid1 row 5, in column 4 i have the value: TEST1
If in my MSHFlexgrid2 row 27 column 1 i also have the value: TEST1, it would select that row and add the backcolor in the cell : MSHFlexGrid2.CellBackColor
How can i do that?
Thanks again for your help
On Error Resume Next
For myRow = LastMatch To MSHFlexGrid2.Rows
If MSHFlexGrid2.TextMatrix(myRow, 1) = MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 4) Then
MSHFlexGrid2.TopRow = myRow
MSHFlexGrid2.Row = myRow
MSHFlexGrid2.Col = 1
MSHFlexGrid2.CellBackColor = &H80FF&
MSHFlexGrid2.CellBackColor = &H80000005