Dim r1 As Long, r2 As Long, i As Long Dim test1 As String For r1 = 1 To MSHFlexGrid1.Rows - 1 test1 = MSHFlexGrid1.TextMatrix(r1, 5) For r2 = 1 To MSHFlexGrid2.Rows - 1 If MSHFlexGrid2.TextMatrix(r2, 10) = test1 Then MSHFlexGrid1.TextMatrix(r1, 14) = "" Else MSHFlexGrid1.TextMatrix(r1, 14) = "NEEDS TO BE REMOVED" MSHFlexGrid1.Row = r1 MSHFlexGrid1.Col = 14 MSHFlexGrid1.CellBackColor = &H80FF& Exit For End If Next r2 Next r1
|Excel Spreadsheet - Send email if certain value is selected.||14||87|
|String manipulation in Visual Basic||7||60|
|Microsoft Access combo box help||2||38|
|How to set the row selection as it was prior leaving the datagrid in vb6||3||35|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!