How do I create 3 list boxes dependent on prior selections

G

Guest

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
 
G

Guest

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?
 
G

Guest

Hi,

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

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a dependent list, to a current list? 1
How do I create multi choice selec drop down list in Excel please 7
How do I create dependent combo-boxes? 3
how do I create a drop down list that assigns certain information 1
How do I make the drop-down portion of a list wider than the cell? 2
How do i create a drop down list from information on another works 2
How do I create a form with drop downs that narrows choices? 1
How do I create "IF" function with a drop down list? 10

Top