I would like to validate from every cell of my MSHFlexgrid1 row 0 with every name entered in my TEXT2 multiLine .
Ex:
If MSHFlexGrid1.TextMatrix(0, 0) is not equal to my TEXT1 1 row of Multiline, it would give me a msg saying that it does not match.
It would validate all cell of row 0 of the MSHFlexgrid1.
How can i do that?
Thanks again for your help
This is what i have for now:
Private Sub rate999_Click() Dim lngCol As Long For lngCol = 0 To MSHFlexGrid1.Cols - 1 If MSHFlexGrid1.TextMatrix(0, lngCol) = TEXT1 .Text Then Else Call MsgBox("Heather doesn't match. Please validate.", vbExclamation, "Heather Validation") Exit Sub End If NextEnd Sub