userform combo box conditional rnages

I've got a userform with mutliple combo boxes

Each of the combo boxes selects from a separate named range

Is it possible to have the options in combo box 2 change depending on the option selected in combo box 1?

eg

combo box 1 choices, 1,2,3,4,5 (named range 1)
combo box 2..........
if combo box is "1" then select from (named range 2) a,b,c,d,
if combo box is "2" then select from (named range 3) X,y,z

then if combo box 2 is X then select from (named range 4) P, Q,R)

I've used combo boxes in my form but there may be an easier way. I am willing to learn.

Thanks in advance.

Hi,

Have you tried using a Select Case statement?

For example:

Please Login or Register  to view this content.

Insert something like this in the ComboBox1_Change() event.

Hope this helps

ajryan88 thanks for your time to help on this problem.

When I click on the second combobox i have no options.


this is the code I have

Please Login or Register  to view this content.

oh okay thats my issue

ill have a looksee in the morning

cheers

I still have the same issue.

Does the RowSource for the combobox have to be empty?

Please Login or Register  to view this content.

it may be easier to create new user forms for the different options.