Posted 7 September 2019, 10:44 am EST
Hello,
How do I modify the code below to highlight rows in C!AOP5 based on fields selected in Grid1?
Private Sub Button3_Click(sender As System.Object, e As System.EventArgs) Handles Button3.Click
C1AOP5.Refresh()
yx = “”
For Each Srow In Me.DBGrid1.SelectedRows
If vc1 > 0 Then
yx = yx & “,” & “'” & Me.DBGrid1.Columns(0).CellText(Srow) & “'”
Else
yx = “'” & Me.DBGrid1.Columns(0).CellText(Srow) & “'”
End If
vc1 = vc1 + 1 If yx.StartsWith(",") Then yx = yx.Substring(1, yx.Length - 1) End If Next apply = True C1AOP5.Refresh() C1AOP5.FetchRowStyles = True End if
Thanks,
Victor