Excel VBA - Conditional drop-down list

K

kermit_piper

I have a drop-down list that populates from a range of cells. This rang
of cells includes criteria for several regions:
test1
test2
test3
test4
test5
test6
test7
test8
test9

What I need to do is if user selects Region 1, drop-down displays:
test1
test2
test3

If user selects Region 2, drop-down displays:
test4
test5
test6

If user selects Region 3, drop-down displays:
test7
test8
test9

Should I break up the lists into separate lists and use an II
statement? If so, can someone show me how I would implement this? Or
is the best solution for this a macro or VBA module. I'm not sure ho
to approach this so if someone could show me I would really appreciat
it.

Thanks in advance,
K
 

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

Populate cells based on key cell 4
Append worksheets together in one 1
Linking Multiple Workbooks 5
Trouble with an Array!!! 6
VC++2003: Methods implemented outside class body are never inlined for templates that are instantiat 5
Send Email Based on Spreadsheet Criteria 8
Opening csv in Word 1
Problem editing a query based on another query and table 3

Top