Combobox Query

[Alice21]

Hi

I am looking to set up a user form with multiple comboboxes so that when you select an item from the first box the list in the second box only shows options that are relative to the first box. To be able to do this do i need to set up multiple lists first?

I've never had to do this before so I'm looking for starter points

[MaczaQ]

is it possible.
One from many ways to do this is:
1. Create UserForm
2. Create two controls (ComboBox)
3. Change name of first ComboBox into "cmb1"
4. Change name of second CombBox into "cmb2"
5. Paste below code into UserForm code section

Please Login or Register  to view this content.

5. Enjoy it !
P.s. I attached working example of that UserForm

[Alice21]

Thank you, I'll have a look and see if that works
Many Thanks

---------- Post added at 10:34 AM ---------- Previous post was at 10:30 AM ----------

I can't open the ZIP files

[MaczaQ]

just do step by step what I wrote in points - that's have to work

[Alice21]

OK.
Could you explain this part of the code just so i understand it...

list1 = Array(1, 2, 3, 4)
list2 = Array(5, 6)
list3 = Array("a", "b", "c", "d", 7, 8, 9)

[MaczaQ]

when you will select first value ("zero") in combobox1 then values from Array (list1) will appear in Combobox2.
The same way if you will select 3rd value in combobox1 then values from Array (list3) will appear in Combobox2.

Of course presented values are only examples, You can use there any values You need.

[Alice21]

I'll give it a go....Thanks