comboBox colour change depending on selection

[bensplace]

I am using excel 2007 and i want to change the background colour of a combBox(Active control) depending on what is selected.
So I have a simple Yes/No selection that is blank to start off with.
When it is blank i want the colour to be default, but when you choose Yes i want the backgroung to change to green and when No is selected i want the colour to change to red.
I know I can do this in VBA but I do not know the code to use.
If any one can help me you may well get me a gold star at work

Thanks for looking

 

[ChrisM]

try this:

Private Sub ComboBox1_Change()

With ComboBox1
    Select Case .Value
        Case "yes"
        .BackColor = &HC000&
        Case "no"
        .BackColor = &HFF&
        Case Else
        .BackColor = &H80000005
    End Select
End With

End Sub

 

[bensplace]

Excellent, worked a treat, thanks so much, cant wait to go to work tomorrow now lol