ComboBox BackColor change on value

[KennyA]

I have a ComboBox that I am trying to get the BackColor to change based on a selection.
There are 11 ComboBoxes on the sheet. After I have gone through all the boxes and made the selections
I hit the finish button which runs the VBA code.

Using ActiveX ComboBox. This is the code I tried using. I am obviously doing something wrong.
I want TERMINAL BOX to be green and NONE to be red

With ComboBox11
Select Case .Value
Case "TERMINAL BOX"
.BackColor = &HFF00&
Case "NONE"
.BackColor = &HFF&
Case Else
.BackColor = &HFF00&
End Select
End With

 

[Fluff]

In what way doesn't it work?

 

[KennyA]

In what way doesn't it work?

The back color doesn't not change

 

[KennyA]

Let me add this as well. If I use YES in the code replacing TERMINAL BOX and NO for NONE the back color does change

 

[Fluff]

What values do you have in the combo?

 

[KennyA]

None
terminal box
lcp
lcp-aso

 

[Fluff]

The only reason I can think it would work if you use Yes & No is if the combo has multiple columns, some of which are hidden.

 

[KennyA]

Thanks
I will look into that

 

[Fluff]

OK.

 

[KennyA]

That was not it. The ComboBox has one bound column