Listbox to source two sets of data

Hi All.
I am having trouble with a userform that has a ListBox for Data and a ComboBox that picks which set of data to populate the ListBox.
If I use the 'ListBox' properties to acquire the row source then I will need two Userforms but I would like to use one form and alternate the ListBox information based on what is selected in the ComboBox.
Please help.
Here is my Code.

Please Login or Register  to view this content.

Thanks bakerman2.
This was a big help. I made one change as the code didn't work for me, well two changes (I set the end of the Range as well).
Your code might work as well but I thought I would add my changes as an option for anyone else looking at doing something similar.

I swapped - "With ListBox1.Clear" for - With ListBox1.RowSource = ""- I think these do the same thing so thanks again.
I will be marking this 'Solved' shortly

Please Login or Register  to view this content.