Cascading ComboBoxes all inside a userform?

[CtrlAltDelete]

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

Please Login or Register  to view this content.

I have asked this on another forum before coming here.

[Thatguy03]

You are looking for a Cascading Combo box set which will allow you to filter data for one combobox depending on the first one. This video should help you https://www.youtube.com/watch?v=SpMyGlEInGs

[CtrlAltDelete]

I should have clarified, I am using Excel not Access. Can this only be done in Access?

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[CtrlAltDelete]

Thanks -->UL.xlsm

[Norie]

Why are you referring to zcode?

That's textbox not a combobox.

Also, why are you hiding zamps?

[CtrlAltDelete]

ok so the zcode should be ztype (was a typo). I was going to try to hide the zamps, because I thought if the value is already filled I don't need to enter it except with price sign. However, I really don't care if they hide or not. I have changed my code in my post to prevent any future confuion. Thanks

[CtrlAltDelete]

I fixed the code after the typo and it worked. Thank you so much Norie.

Here is the correct code.

Please Login or Register  to view this content.