Change ComboBox Options

[sgp]

Hi all

I have 2 comboboxes on a UserForm and i'm struggling to code out the options I would like to see based on the first selection.

For example:

1 - If you select option 1 from combobox1, then combobox2 options displays 'a', 'b' and 'c'

2 - If you select option 2 from combobox1, then combobox2 options displays 'x', 'y' and 'z'



Many thanks

[john55]

hi,
as an option try it and see if it helps you

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[sgp]

This did help me - thanks john

[john55]

glad to be of help!

[snb]

which can also be written as:

Please Login or Register  to view this content.

But my preference:

Please Login or Register  to view this content.

[sgp]

Hi snb,

Thanks for the code - Just a quick question - How could I show the same in excel alone and not vba.