Changeing Combobox Colors based on other combobox selections

[dagindi]

Im using the following code in a VBA project:

Please Login or Register  to view this content.

I tried modifying it as follows so that when something is selected from this combobox the next combobox changes color but it doesnt work:

Please Login or Register  to view this content.

Any suggestions??

[nilem]

maybe so

Please Login or Register  to view this content.

[RaulRodriguez]

Try this:
Private Sub ComboBox1_Change()
Select Case Me.ComboBox1.Value
Case "": Me.ComboBox1.BackColor = vbGreen
Me.ComboBox2.BackColor = vbBlue
End Select
End Sub

[dagindi]

Nilem\Raul,

Thanks for the quick responses. I went with Nilem's response (since it came in first) and it worked perfectly.

Thanks to both of you!!