Auto populate text box on userform

[sara1989]

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

[sara1989]

cAN ANYONE HELP MEEEE PLEASE

[naveenmarapaka]

Hi , Pls elaborate your full requirement..... like what are details1 and details 2 in attached... how do you want this to be operated..
Based on which combobox ? in your explanation...

[sara1989]

naveenmarapaka
- My sheet has slightly changed now see new sheet attached.

Detail1 1 and details 2 boxes i can populate based on 1 list for each just like normal selection boxes
But each line i require the Items combo boxes to show a list of all items and then once the item is selected the rest of that line the boxes will populate and show values related to the first item selected.Clothing Order Form.xlsm

[naveenmarapaka]

got you, will catch you soon if iam able to get something for you....

[sara1989]

Thanks any help is appreciated. I know a little about vba but not much thanks

[naveenmarapaka]

Hi , Check the attached, I have just made part of your project.... you have go long to complete your project....

[sara1989]

naveenmarapaka - I have now downloaded this but nothing is populating in any of the boxes?
am i being stupid

Thanks

[naveenmarapaka]

its working to me... anyway you just check the code , you will get an idea...

[sara1989]

ok ill see if i can work this out?
Nothing is populating so unsure here to start ?
Thanks

[sara1989]

naveenmarapaka Are you able to re-send the sheet to me incase i have received the wrong version. im not great with vba so unable to work out what's wrong?

I am just opening the sheet and clicking my open order button but no items are available in the first items box ? and therefore the rest of the boxes?