I need a drop down menu (Validation "List", maybe?) and show different colors on the drop down menu.
I changed some cell colors and Insert:Nameefined them as "Colors" then I went and did a Data:Validation:List:=Colors and it did the drop down like I thought but it had no colors.
I need the user to have a drop down menu with an assortment of colors to choose from.
Can this be done with VBA?