Data should be filled up in List box based on Selection in Combo Box

Hi Friends,

I have a Excel Workbook with 2 worksheets.

Worksheet " Central Acts" has 2 columns and Worksheet "State Acts" has 31 columns. When workbook is opened a userform will load and this userform has a combobox and listbox.

When I select the value "Central Acts" in the combo box, the List box should be filled up with the 2 columns from the worksheet "central acts".

When I select any other value from the combo box, the Listbox should be filled up with the data in the worksheet "state acts" with the data contained in same column as the value selected in combo box.

Looking for your help and solution.

Thank You royUK.

It was very helpful.