Change ListBox rowsource to another data set from ComboBox selection

Hi. I have a userform with a listbox and a combobox.
in a worksheet named "Data" there are 2 tables of data, "Table1" and "Table2"

With the ComboBox having two possible selections - table1 or table2
I want to fill the listbox with rows from the table (1 or 2) that is selected in the combobox

Is there a way to update the ListBox with a new data set when the ComboBox selection is changed?

Yes there is a way

Kind regards
Leo

Assuming the number of columns in the listbox & the table are the same:
Maybe something like this:

Please Login or Register  to view this content.

Thanks Akuini.
I was stuck on this - probably over complicating it.
Cheers Bro'