cascading combo boxes...???

[Gurps]

is there any way in which I can get the selection from one combo box to influence the second?? In other words, The second combo box is dependant on the first.
I am using Excel XP.

any help would be appreciated.
cheers

 

[djd79]

Aladin,
I'm not sure what you are asking here.
Daniel

 

[Aladin Akyurek]

Aladin,
I'm not sure what you are asking here.
Daniel

I'm asking for example data along with a description of the way you want the lists to be dependent.

 

[Mark_G]

I was wondering if it is possible for the indirect function as described above to work for dynamic ranges. I have tried it but the pull down in the second column does work. If I make the range a fixed range it works, however I would really like to have the dynamic range.

Mark

 

[Aladin Akyurek]

I was wondering if it is possible for the indirect function as described above to work for dynamic ranges. I have tried it but the pull down in the second column does work. If I make the range a fixed range it works, however I would really like to have the dynamic range.

Mark

See for an approach:

http://www.mrexcel.com/board2/viewtopic.php?t=85753&highlight=offset+validation

 

[zanoman]

Indirect function together with several dropdown menus with data - validation <<<---- Is this possible? Ive got two dropdown menus and they are working like a charm. However, i want to have 3 or 4 dropwdown menus and depending of which choice i choose from the first 2-3 i will get some new choices from in the 4th dropdown menu.. Ive tried tha indirect function but i can only get this working together with 2 dropdowns..

Eric

 

[Zack Barresse]

Yes. Check out Juan's contrib here ... http://www.vbaexpress.com/forum/showthread.php?t=1072

I also have a workbook example with this in place already. If you'd like a copy, pm me with your email addy.

 

[Aladin Akyurek]

Indirect function together with several dropdown menus with data - validation<<<---- Is this possible? Ive got two dropdown menus and they are working like a charm. However, i want to have 3 or 4 dropwdown menus and depending of which choice i choose from the first 2-3 i will get some new choices from in the 4th dropdown menu.. Ive tried tha indirect function but i can only get this working together with 2 dropdowns..

Eric

As long as you define the sublists as referring to definite ranges (thus, not using formulas with OFFSET, INDEX...), INDIRECT() will suffice to construct cascading or dependent lists...

aaCascadingDataValidLists zanoman.xls
	B	C	D	E	F	G
1
2	FRANCE		COUNTRIES		USA	FRANCE
3			USA		NewYork	Paris
4	Nice		FRANCE		Pittsburgh	Nice
5
6	NIC1				NewYork	Paris
7					N1	PAR1
8					N2	PAR2
9
10					Pittsburgh	Nice
11					P1	NIC1
12					P2	NIC2
13
Sheet1

COUNTRIES refer to:

=Sheet1!$D$3:$D$4

USA refers to:

=Sheet1!$F$3:$F$4

FRANCE refers to:

=Sheet1!$G$3:$G$5

NewYork (without space) refers to:

=Sheet1!$F$7:$F$8

Pittsburgh refers to:

=Sheet1!$F$11:$F$12

Paris refers to:

=Sheet1!$G$7:$G$8

Nice refers to:

=Sheet1!$G$11:$G$12

Data validation in B2...

Allow set to List, Source to:

COUNTRIES.

Data validation in B4...

Allow set to List, Source to:

=INDIRECT(B2)

Data validation in B6...

Allow is set to List, Source to:

=INDIRECT(SUBSTITUTE(B4," ",""))

 

[zanoman]

How about dropdown menu with data validation and checkboxes? From a pulldown menu you are allowed to pick a checkbox containg "X" or a chackbox containing "V". As in ok (V) and not ok (X). Is this "doable"?


Eric

 

[TTom]

I tried the USA-FRANCE example...
It answered who to access Data Validation List from another sheet's data AND how to do a parent - child relationship.
SWEET! TTom

 

[tz62lm]

Match function

thanks for the info. but I'm have 4 columns of data validation. each one is dependent on the previous. And the issue is when any of the data values is duplicated, Excel doesn't handle this well with the formula I'm using with INDIRECT and MATCH.