Combo Box Input Range - Variable

[Guest]

I'm using 2000 and have a sheet where 2 selections have to be made.

Selection 1 is in a Forms menu Combo box with 5 choices and works great.

Selection 2 I would like to be a Forms menu Combo box, with the selection
list changing for each choice in box #1. How can I code the 2nd combo box's
input range so it changes based on the selection in box #1?

I tried an If statement to parse the 1st box's choice, then display either
the range or range name. But I couldn't get this result to be used the 2nd
box's Input Range. I'm rather limited in VB skill I guess. Any help is
appreciated.

Alex

 

[Debra Dalgleish]

Another option is dependent data validation, as described here:

http://www.contextures.com/xlDataVal02.html

 

[Guest]

Thanks, I'll check it out.

Alex

Another option is dependent data validation, as described here:

http://www.contextures.com/xlDataVal02.html