Adding dynamic named ranges to combo boxes in userform

Hi.

I'm hoping this is something simple that can be fixed. What i am trying to do is i have a userform with 2 combo boxes. The first combo box has a validation list i am pulling from a sheet with the following code:

Please Login or Register  to view this content.

What i need is when the user selects a value in the first combo box, only certain values for the second combobox that are applicable to the value in the first combo box should show. This is the code i have tried to use but had no luck.

Please Login or Register  to view this content.

So if i pick Test1 from combobox1, the validation list in cell D1 should be filled into combobox2 however this is not the case. If i pick Test1, combobox2 has no values in it.

Any help is appreciated!

Hi

I would recommend that you read this:

http://contextures.com/xlDataVal02.html

come back if you still need help afterwards.

Originally Posted by mehmetcik

Hi

I would recommend that you read this:

http://contextures.com/xlDataVal02.html

come back if you still need help afterwards.

That's where i got the idea from.

What about adding the third combo box, how can we do that, I tried but in vain. any help would be highly appreciated. Thanks in Advance

Originally Posted by john55

see if it helps you

This worked perfectly. Thank you.

Originally Posted by khan2013

What about adding the third combo box, how can we do that, I tried but in vain. any help would be highly appreciated. Thanks in Advance

Did you try Johns code?