Userforms - VBA

[12james]

Hi

I am looking to create a userform with combo boxes the trick is when I select an option in Combo1 then the choice in Combo2 is driven by the first selection.

Any help would be very much appreciated.

 

[Smitty]

Welcome to the Board!

This may get you started:

http://www.contextures.com/xlDataVal10.html

HTH,

 

[12james]

Smitty

Cheers but I dont think this is exactly what I am looking for are there any other suggestions I have been looking for this for a while and I am starting to hate comboboxes

 

[John_w]

Search this board for linked comboboxes and dependent comboboxes - there are plenty of examples.

 

[Greg Truby]

How do you think one does it? What event do you think would be most appropriate? What is the basis for populating the dependent list? Are the lists in the dependent defined within ranges on a worksheet? Or as arrays, existing only in code?

Once you work your way through these kind of questions you can put together a starting form. Then, when you get stuck, show us what you came up with and we can nudge you in the right direction.

========

Heya, Smitty.

 

[tusharm]

No, it might not be exactly what you were looking for but the concept is the same. For a solution that works with data in relational tables see
Cascading queries
http://www.tushar-mehta.com/excel/newsgroups/cascading_dropdowns/index.html

Smitty

Cheers but I dont think this is exactly what I am looking for are there any other suggestions I have been looking for this for a while and I am starting to hate comboboxes