I have a form with a list box, I would like to change the row color if a row has certain data present. The code so far is
// start code
' change row color for any member marked C_hange or T_erminate
For iIndex = 0 To giNumbMemberRowsSelected - 1
If Me.lsbMembers.Column(1, iIndex) = "T" Then
ElseIf Me.lsbMembers.Column(1, iIndex) = "C" Then
End If
Next iIndex
// end code
if "T" is present I would like to change the row color to red, if "C" to blue.
tia Jack
// start code
' change row color for any member marked C_hange or T_erminate
For iIndex = 0 To giNumbMemberRowsSelected - 1
If Me.lsbMembers.Column(1, iIndex) = "T" Then
ElseIf Me.lsbMembers.Column(1, iIndex) = "C" Then
End If
Next iIndex
// end code
if "T" is present I would like to change the row color to red, if "C" to blue.
tia Jack