Need help populating a second Combobox !

[Petter120]

Hi !

I have two comboboxes "ComboBox1" and "ComboBox2".

I want ComboBox1 to controll whats populates in ComboBox2.
If i pick Sheet6 in ComboBox1 i want ComboBox2 to populate whit data from Sheet1 (or whatever sheet i chose).

The code below populates the ComboBox2 whit the sheet name that is picked in ComboBox1, but i want to beable
to chose a specific sheet.

Is it possible make this happen ?

Please Login or Register  to view this content.

Best regards

Petter

[pike]

Hi Petter120
Something like...

Please Login or Register  to view this content.

[Petter120]

Exactly Pike

Thank you verry much, trying to figure this one out for a while

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save