Solved: Combo Box - Drop Down Menu with Colors

[jason_kelly]

Hi There,

I need your help in creating a unique Macro that would allow for a drop down menu with the colors specified below (rather than text) on a userform, that would have the color appear and the user to be able to select a color.

For example in the drop menu:

Red
Blue
Green
Yellow

Any help with this is greatly appreciated.

Much thanks in advance,

Cheers,

Jay

[fumei]

Why? What would you gain from this? I would be interested in the reasoning behind wanting to do this. It just seems like being cute.

In any case, I do not think you are going to be able to do it. Dropdowns have text, not blocks of color. So you are going to have text, regardless. At least using a dropdown (combobox).

You could use four Image controls, with each controls being a wee box of the color. They would have to be all visible though - not selectable via a dropdown. This would also add a significant amount of logic that you would have to work out, as dropdown can be set up to return ONE item (of the red, green. blue, yellow), but four Image controls would be independent of each other.