Populate Combobox, controlled by another Combobox !

[Petter120]

Hi i need a little help.

If i have two comboboxes, ComboBox1 and ComboBox2.

In ComboBox1 i can choose eiter "sheet5" or "sheet6"

If i choose "sheet5" i want ComboBox2 to populate whit the data in columns A and B in "sheet1"
and i if i choose "sheet6" i want ComboBox2 to populate whit the data in columns A and B in "sheet2"

Please Login or Register  to view this content.

Best regards
Petter

[jaslake]

Hi Petter120
In the attached I've added two Dynamic Named Ranges that become the Row Source for ComboBox2. I've also added this code

Please Login or Register  to view this content.

Let me know of issues.