I have 3 list boxs that I would want to create first list drop down = STATES
(I.E. NJ,TX,CA....) the 2nd list drop down= code1(I.E.SET,SCB,PAY...)
depending on what was selected in the state drop-down and third dropdown =
code2 (I.E.W1,W2,W4..)DEPENDING ON 2nd list box...I have seen some examples
that has 2 list boxes.I need to know how to do three...Thanks In Advance

For the first list box, the range which the box refers to to get it's
contents would contain static values-- easy for that one. But for the second
and third list boxes, the range which the box refers to would contain
formulas which would pull the contents from arrays elsewhere in the sheet,
based on the selection made in the prior box.

So pseudocode for the formula in the dynamic range would be: "If result of
list box #1 = 1, pull contents from array 1, If result of list box #1 = 2,
pull contents from array 2, etc."

Hope that helps?

"GILBERT" wrote:

I have 3 list boxs that I would want to create first list drop down = STATES
(I.E. NJ,TX,CA....) the 2nd list drop down= code1(I.E.SET,SCB,PAY...)
depending on what was selected in the state drop-down and third dropdown =
code2 (I.E.W1,W2,W4..)DEPENDING ON 2nd list box...I have seen some examples
that has 2 list boxes.I need to know how to do three...Thanks In Advance

Hi,

I am needing the same thing to happen in my sheet. Are you please able to
post some sample formula?

Thanks

"Eddie O" wrote:

For the first list box, the range which the box refers to to get it's
contents would contain static values-- easy for that one. But for the second
and third list boxes, the range which the box refers to would contain
formulas which would pull the contents from arrays elsewhere in the sheet,
based on the selection made in the prior box.

So pseudocode for the formula in the dynamic range would be: "If result of
list box #1 = 1, pull contents from array 1, If result of list box #1 = 2,
pull contents from array 2, etc."

Hope that helps?

"GILBERT" wrote:

I have 3 list boxs that I would want to create first list drop down = STATES
(I.E. NJ,TX,CA....) the 2nd list drop down= code1(I.E.SET,SCB,PAY...)
depending on what was selected in the state drop-down and third dropdown =
code2 (I.E.W1,W2,W4..)DEPENDING ON 2nd list box...I have seen some examples
that has 2 list boxes.I need to know how to do three...Thanks In Advance

Hi,

Don't worry. I found the answers here
http://www.contextures.com/xlDataVal02.html



"Eddie O" wrote:

For the first list box, the range which the box refers to to get it's
contents would contain static values-- easy for that one. But for the second
and third list boxes, the range which the box refers to would contain
formulas which would pull the contents from arrays elsewhere in the sheet,
based on the selection made in the prior box.

So pseudocode for the formula in the dynamic range would be: "If result of
list box #1 = 1, pull contents from array 1, If result of list box #1 = 2,
pull contents from array 2, etc."

Hope that helps?

"GILBERT" wrote:

I have 3 list boxs that I would want to create first list drop down = STATES
(I.E. NJ,TX,CA....) the 2nd list drop down= code1(I.E.SET,SCB,PAY...)
depending on what was selected in the state drop-down and third dropdown =
code2 (I.E.W1,W2,W4..)DEPENDING ON 2nd list box...I have seen some examples
that has 2 list boxes.I need to know how to do three...Thanks In Advance