Populating comboboxes based on selection of values from another comboboxes & capturing val

[excel_126]

Hello,

I want to populate some comboboxes when user selects some particular value from another combobxes in userform.

e.g. If user selects "Apple" from one combobox, then another combobox should be populated with some values.

e.g. If user selects "Mango" from one combobox, then another combobox should be populated.

And values from two comboboxes should be captured in the sheets.

Please help.

[excel_126]

Please help anybody...

[Norie]

Can you give more details?

What comboboxes will be populated with what values when apple/mango is selected?

[excel_126]

Dear Norie,

Many thanks for your reply. I have one user form which populates data into six columns. And user form has 5 comboboxes. If user would select value in 5th combobox, then another combobox should come automatically. It should show another list of values. Then these values along with 5 values from comboboxes should be captured in the sheets.

Also, when apple would be selected from 5th combobox of userform, another combobox should display options like "Raw & Juice"
Also, when orange would be selected from 5th combobox of userform, another combobox should display options like "Small, Medium & Large"

I hope that I have explained everything.