UL.xlsm
Is this possible?
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 labeled as Quantity.
UL.xlsm
currently this is the code I have tried with no luck
![]()
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.Visible = False UserForm1.zamps.Value = "3" End If If ztype.Value = "Parallelgram" Then UserForm1.zamps.Value = "2" End If If ztype.Value = "Price Sign" Then UserForm1.zamps.Value = Quantity End If
I have asked this on another forum before coming here.
Bookmarks