[RESOLVED] Combo box items
Please help! (And I apologise if this seems overly long).
I am working on a userform in Word 2003. Amongst other things, the form contains several combo boxes. When the form is initialised:
- Items A and B are added to ComboBox1
- Items X, Y, Z, P, Q and R are added to ComboBox2.
Now I am trying to restrict the list of items from ComboBox2 depending on the choice made from ComboBox1. For example if item A is selected in ComboBox1, I would like only X, Y and Z to be available from ComboBox2. But if item B is selected in ComboBox1, I would like only items P, Q and R to available from ComboBox2.
I would also like to load a default value to ComboBox2 depending on the selection made in ComboBox1. For example, if item A is selected from ComboBox1, I would like ComboBox2 to display item X, although X, Y and Z would be available for selection.
The reason I am adding all items to ComboBox2 in the first instance is because there may be occasions when ComboBox1 s left blank, but a choice is still made from ComboBox2.
Re: [RESOLVED] Combo box items
Thanks - perfect solution :)