Populate Listbox in Userform with named ranges with the help of option buttons

[Simsonso]

Hi all,

I have a Listbox1 in a Userform which is populated in RowSource with a named range.
Now I want to add options buttons and populate Listbox1 with other named ranges depending on the option button.

I tried a few codes but nothing is rellay working how it should.
Does anyone have a simple solution for this?

kind regards
Simon

[rorya]

The basic code is just:

Please Login or Register  to view this content.

If you need more specific assistance, you'll need to provide us with more detail - preferably a sample workbook.

[torachan]

give us a workbook to work with.
see big yellow banner - how to upload a workbook.
you have chosen the worst method of populating a listbox/combobox.
torachan.

[emina002]

I get your point.
I imagine this with 2 listbox.

Name range is "Category" on the listbox1 will appear Fruit,Color,Shape..

So if I choose Fruit--another set of list will appear like apple, banana, oranges, lime, you can set a named range on this list as "Fruits", and then set an if condition to your listbox1 that if listbox1 option Fruit has been chosen, name range/row source of listbox2 will be "fruits".

I guess this is the process you want?

[torachan]

you could use cascading comboboxes - as you progress through the sequence each filters to the next level.
torachan.