Multi Listboxes with data dependent upon user choices

[Guest]

I have 4 Listboxes. The way it works is user selects item from box 1 and
moves to box 2. Where I am having problems is depending on what is in box 2
decides what is shown in box 3. How do I do this?

Box1 rowsource = A3:A39
When A3 is in Box2 I want to have A43:A56 in Box3.

 

[Guest]

Is this even possible?

 

[Dave Peterson]

There are lots of ways to achieve what you want. Maybe you could use range
names???

Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html

Her example is using data|validation cells, but maybe you can use something
there.