userform combobox fills from selection on sheet

Hello all,

I am stuck trying to fill comboboxs on a user form from what a person selects on the sheet.

In attached if person picks 5 fruits from the list each combobox will load the 5 choices.
The fruits are listed in column B while the person will put an X in column C.
The fruits in B with the X in column C will load in combo box.

This sounds easy but not for me.

Please take a look at attached.
Any help is appreciated.

Hi mdshotgun

Remove the code from open workbook event
and in the userform add

Please Login or Register  to view this content.

and change the showmodlal setting of the userform to false

Hi,

Put this in the userforms code

Please Login or Register  to view this content.

When the userform loads, it will take the values marked with x and put them in each combobox

Yes,

Put this in the userform code

Please Login or Register  to view this content.

Create similar codes for cb2-5

or:

Please Login or Register  to view this content.

On which line is it giving an error?

*EDIT

By the way, if it's only possible to select a different value in each combobox, why not populate each combobox with a different value, and skip the user selection?

You could have adapted the code yourself

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Thanks for the rep. whicc code did you use?

I know you cannot use RemovItem if the Combo is populated using RowSource, I'm not sure about List Ptroprty. Hence, I used a Loop to load each combo using AddItem