Combo Box - Drop Down Menu with Colors

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 in the list 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

What do you mean by drop down menu?

Can you use some of this to build a userform to suit your needs? I use this to fillcolor the active cell, and it also returns the color index number in a msg box so that you know the number of the color. See attached.

Originally Posted by jason_kelly

Cool!

That will do.

Excellent!