How do I increase conditions in a Case argument??

Morning All,

I've written this code which selects parts based on 3 variables but realised there's another consideration which requires insertion.
I need to insert the consideration 'If ComboBox42 says "Conical" also.
Any ideas how I can do this?

Thank You

Private Sub ComboBox17_Change() '

    
    Select Case Me.ComboBox10.Value
    
    
    Case "4/100" 
        
            If ComboBox17.Value = "M12" And ComboBox7.Value = "C" Then
                Me.ComboBox31.Value = "HUBAC001"  
                Me.ComboBox32.Value = "BRNGA001"  
                Me.ComboBox33.Value = "NOT REQUIRED" 
                Me.ComboBox34.Value = "NUTA002" 
                Me.ComboBox35.Value = "510237"   
                Me.ComboBox36.Value = "HBCAP004"  
                Me.ComboBox37.Value = "NUTW001"   
                
              
            End If

End Select

End Sub

Ah good man, Its works fine. Just one more thing, in the box which contains Conical there are only two variables: Conical and spherical,

The userform defaults at Conical and the above code works fine. However, if I change to Spherical and insert the other conditions, and then change to Conical, it doesn't change?

In other words, the conical/spherical will produce different outcomes which I'll need to switch between. Sorry to be a pain:-/

Ok, thank you for that. I'm unsure at the moment how to tackle the logic, but it works for now. Thanks xlnitwit