Hi all
i Have created a userform to place an Clothing order.

What i need is help with how to populate a couple of text/combo boxes based on a combo box
I have my data in a sheet and labelled DATA

when the use selects the item from the combo box i need the code, Size and Colour and Embroidery/print populating.

The Size box needs to show the relevant sizes . not all items have the same size range.

Any help is appreciated
my sheet is attached for refrence

Thanks Clothing Order Form.xlsm