Hi Everyone
Another one of those obscure (to me) problems that is difficult to sort!
I have a Combobox on a UserForm.
Using code I change the .Backcolor property to change the "fill" colour of the box based on its contents i.e. Red, Amber Green (using RGB(x,y,z) in a Select Case construct)
A sort of coded conditional format.
This works fine but....
When I select the list with the dropdown button, the background of the list is also in colour - yuk!!!
How can I get the background colour of the list to remain white as in a cell Data Validation list?
I don't want to use a cell Data Validation List.
As ever WTIA
barry
Bookmarks