How to change the color of a row in a list box

[dogdays]

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

 

[ThomasB]

Hi There

This link may help you:

http://www.andypope.info/vba/colourdropdown.htm

Kind Regards

Thomas