items in combobox2 depending on combobox1

**minifreak** · 09-15-2012, 08:09 AM

I'm looking for the correct If Then solution that can add items to combobox2 depending on the choice that's made with combobox1
So combobox1 has three choices (X, Y, Z). When a user selects X, the 2nd combobox should display A, B and C.
When a user selects Z in the first combobox, the 2nd should display G, H and I
Hopefully I explained good enough what I'm looking for and can I expand a working situation myself with other options

**Jacc** · 09-15-2012, 08:25 AM

Something like this? I was in a hurry so I used whatever came to mind instead of your letters.

**john456852** · 09-15-2012, 08:39 AM

what happens when "y" is chosen?

Depending combo boxes.xlsmHere is file
i modified other guy's . imade it correct
no errors!

**minifreak** · 09-15-2012, 10:01 AM

thx sofar for the help but is it possible to use this in a userform ??
so when I press a button on Sheet1, the userform opens and inside this form there are the comboboxes visible

Originally Posted by john456852

what happens when "y" is chosen?

I'm still figuring out all the options that should be available but if I have a start I can modify all the options later myself

**HaHoBe** · 09-15-2012, 10:15 AM

Hi, minifreak,

the normal to attach to the button is simply the call the userform:

Sub CallUF()
UserForm1.Show
End Sub

Behind the userform place the following code

Private Sub ComboBox1_Change()
With ComboBox2
  .Clear
  .ListIndex = -1
  Select Case ComboBox1.Value
    Case "X"
      .AddItem "X 1"
      .AddItem "X 2"
      .AddItem "X 3"
    Case "Y"
      .AddItem "Y 1"
      .AddItem "Y 2"
      .AddItem "Y 3"
    Case "X"
      .AddItem "Z 1"
      .AddItem "Z 2"
      .AddItem "Z 3"
  End Select
End With
End Sub

Private Sub UserForm_Activate()
ComboBox2.ListIndex = -1
With ComboBox1
  .Clear
  .AddItem "X"
  .AddItem "Y"
  .AddItem "Z"
End With
End Sub

Please alter the names to suit. Within the Select Case you can add other or more items if wanted.

Ciao,
Holger

**minifreak** · 09-15-2012, 10:46 AM

Thx Holger,

Now I see how the code needs to be written and how it works, I think I can use it very much to create a userform with comboboxes but also maby some more comboboxes
You all helped me a lot !!