combo box in a cell

[bogd1n]

i try to make a combo box in a cell but in my file not succsed to make discret for example in fille in atachament "for example i refer in combo cell pink black blue
if you help me with a little tutorial how make this type of combo and haw assign values
i want to make this example it is very discret and help me




t2.xlsm

tks for help me

[pjwhitfield]

Apologies, Im confused, the combo box (data list validation) youve set up in B2 is (in my opinion anyway) the best tool for the task you want ie have a drop down list in a cell. Using form combos etc is prone to problems and formatting issues. Cant you just use that?