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.

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.

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