Multi Listboxes with data dependent upon user choices
 

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.

Multi Listboxes with data dependent upon user choices
 

Is this even possible?

"SaturnGolfBoy" wrote:

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.

Multi Listboxes with data dependent upon user choices
 

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.

SaturnGolfBoy wrote:

Is this even possible?

"SaturnGolfBoy" wrote:

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.

--

Dave Peterson