Hi,
I have constructed a user form with a set of comboboxes containing a number of choices. However, the different alternatives depend on each other, and instead of having all the choices available in the second combobox I would like to only have the "correct" ones depending on the choice made in the earlier combobox.
For example;
---------------
A-B-C
Car-Blue-USA
Car-Red-USA
Truck-Green-Sweden
Truck-Blue-Sweden
If I choose Car in the first combobox, I would like to only have the choices [Blue, Red] available in the second combobox, not the full set of data [Blue,Red,Green] and so on.
However, I have two problems construction this;
1) If I make the rowsource A1-A4 for the first combobox, I get the alternative [Car,Car,Truck,Truck], not [Car,Truck]. It is possible to come around this problem by making a unique list in addition to the linked list showed above, such as;
A-B-C
Car-Blue-Usa
Truck-Red-Sweden
-Green-
2) To make the comboboxes depend on each other, and alternate the available choices according to the choice made in an earlier combobox.
I have attached an example of a userform and list, and where I am at the moment.
Combobox1-button, problem1 and problem 2
Combobox2-button, only problem2
Bookmarks