How do I create 3 list boxes dependent on prior selections

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