Cascading ComboBox 3 or 4 conditional..

[feroguz]

Hi ExForum User's!

I have 3 combobox:
Combobox5
Combobox6
Combobox10

I need when put "Calidad" & "MCC" --> Give me "X information"
When I put "Calidad " & "SwitchGear" --> Give me "Y Information"
When I put "Produccion" & "MCC" -->give me "z Information"
------

I need what it's the command to add to create the cascading option:
I have this code:

UseForm_Initialize

Private Sub UserForm_Initialize()

  With Me.ComboBox10
         .AddItem "Calidad"
         .AddItem "Producción"
                  
     End With
 
 With Me.ComboBox6
         .AddItem "MCC"
         .AddItem "SwitchGear"
         
     End With


End Sub

And in the combobox:

Private Sub ComboBox6_Change()
Me.ComboBox5.Clear
 
    Select Case Me.ComboBox6.Value
    
         Case "MCC"
             With Me.ComboBox5
                 .AddItem "Inspección Recibo"
                 .AddItem "Inspección Proceso"
                 .AddItem "Pruebas"
                 
             End With
        
          Case "SwitchGear"
             With Me.ComboBox5
                 .AddItem "Inspección Recibo"
                 .AddItem "Inspección Proceso"
                 .AddItem "Pruebas"
                 
             End With
             

             
        End Select
             
End Sub

Best Regards!!

[feroguz]

I'm only need the command to put in the case "Condition1"&"Condition2"..

Select Case Me.ComboBox6.Value
    
         Case "Calidad"& "MCC" 
             With Me.ComboBox5
                 .AddItem "Inspección Recibo"
                 .AddItem "Inspección Proceso"
                 .AddItem "Pruebas"
                 
             End With

Any Help??

[feroguz]

Solve it myself, add this:

  Select Case Me.ComboBox6.Value & Me.ComboBox10.Value
    

    'Se agregan ambas condicionales del combobox 6 y combobox10

'---"MCC"
          Case "MCC" & "Calidad"

With this Include the 2 or 3 conditions..