Indirect ListfillRange for Combobox

[milo1984]

Hi,

I have a form with a few comboboxes. based on the outcome of another combobox. the list ranges are named for example as "AAA_CC" or "BBB_CC" or "CCC_CC"

first combobox has a linked cell which then feeds another cell to give the list range. I am struggling to get the ComboBox to produce the dynamic list.

I would prefer not to use VBA.

Any help would be appreciated.

Many thanks in advance.

[PFDave]

If you could upload a sample file we can advise. Thanks

[milo1984]

Hi,

please find attached. so to confirm, it is the second combobox which I would like to produce the list based on the output of the first combobox.

In Cell L4, I have put the List reference if that helps.

Many thanks once again.

[PFDave]

Hi Milo,

I'm sorry I don't know how this could be done without VBA but still using ComboBox's

Using Data Validation you wouldn't need to use VBA.

Maybe someone else knows more about this than I do.

regards

[xlnitwit]

Hi,

Define a name called Second_List whose RefersTo property is
=INDIRECT("List_"&Sheet1!$L$2)
and then use Second_List as the Listfillrange for the second combobox.

[PFDave]

Hi,

Define a name called Second_List whose RefersTo property is
=INDIRECT("List_"&Sheet1!$L$2)
and then use Second_List as the Listfillrange for the second combobox.

So obvious! Nice Catch

[milo1984]

that's brilliant.

Thanks a million

[xlnitwit]

You're welcome.

Please remember to mark the thread Solved.

[SPHINIX]

This is so helpful! Thanks for your response

[SPHINIX]

thanks a lot