Add RowSource list to ListBox based on Selected Sheet

[pipoliveira]

Dear All,

Trust you're all well.

I have created few sheets with different products. I have created the same Named Range (Product_List) to all with Sheet scope.

I want the user to choose the product, based on the sheet name and the named range to appear on the listbox of userform.

So far I am not able to set the listbox RowSource.

I have attached the file.

Any assistance will be highly appreciated.

Best regards,
Filipe

[rorya]

All you need is:

Please Login or Register  to view this content.

[bakerman2]

Also, make your ranges dynamic instead of refering to an entire column.

[dotchiejack]

Is this what you are looking for?
I Created 3 tables for the 3 lists.
See attached.

[pipoliveira]

Hi Rory,

Wow !

And I thought I needed a big code or such... and all I needed was just a line

Thanks a million for your help in here, really appreciated.

Have a great weekend,
Filipe

[pipoliveira]

Hi There,

Thanks a million for your code.

It did worked well alright but the only thing I do not want is to create tables for the named ranges.

The file I have attached in only for test purposes.

On the Original file, when user creates a new sheet, it will create the same named range. The only thing it will change will be the sheet name.

I am thinking now to create a dynamic named range without creating a table for it.

Thanks a million anyway. I might use your code for other projects

Best regards,
Filipe