change the value in a combobox based off another combobox all within a userform.

[Glitch_]

I have a userform with a series of Comboboxs. The idea is when you change the combobox "ztype" it changes the comboboxs "zamps", in every case but one.

When " ztype" is Awning Lighting then amps is 1
When " ztype" is 27in Channel Letters then zamps is 2
When " ztype" is 36in Channel Letters then zamps is 2
When " ztype" is Coffee Sign then zamps is 1
When " ztype" is Light Bar then zamps is 3
When " ztype" is Marketing Case then zamps is 2
However, when ztype is Price Sign zamps needs to offer a list that I have labled as Quantity.

currently this is the code I have tried with no luck

If zcode.Value = "Awning Lighting" Then
         UserForm1.zamps.Visible = False
         UserForm1.zamps.Value = "1"
         
        End If
         If zcode.Value = "27in Channel Letters" Then
           UserForm1.zamps.Visible = False
          UserForm1.zamps.Value = "2"
        End If
         If zcode.Value = "36in Channel Letters" Then
           UserForm1.zamps.Visible = False
          UserForm1.zamps.Value = "2"
        End If
         If zcode.Value = "Coffee Sign" Then
           UserForm1.zamps.Visible = False
          UserForm1.zamps.Value = "2"
        End If
         If zcode.Value = "Light Bar" Then
           UserForm1.zamps.Visible = False
          UserForm1.zamps.Value = "1"
        End If
         If zcode.Value = "Marketing Case" Then
           UserForm1.zamps.Visible = False
          UserForm1.zamps.Value = "3"
        End If
         If zcode.Value = "Parallelgram" Then
           UserForm1.zamps.Visible = False
          UserForm1.zamps.Value = "2"
        End If
         If zcode.Value = "Price Sign" Then
           UserForm1.zamps.Visible = True
          UserForm1.zamps.Value = Quantity
        End If

I have asked this on another forum as well. Change value in a combobox based off another combobox all within a userform?

 

[Glitch_]

Was just a a few typos in the code. Works great now.
Here is the correct code.

Private Sub ztype_Change()


If ztype.Value = "Awning Lighting" Then
                UserForm1.zamps.Value = "1"
                 End If
         If ztype.Value = "27in Channel Letters" Then
                   UserForm1.zamps.Value = "2"
        End If
         If zcode.Value = "36in Channel Letters" Then
          UserForm1.zamps.Value = "2"
        End If
         If ztype.Value = "Coffee Sign" Then
            UserForm1.zamps.Value = "2"
        End If
         If ztype.Value = "Light Bar" Then
           UserForm1.zamps.Value = "1"
        End If
         If ztype.Value = "Marketing Case" Then
                 UserForm1.zamps.Value = "3"
        End If
                 If ztype.Value = "Price Sign" Then
                 UserForm1.zamps.Value = "Select"
        End If
        
End Sub