View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jody
 
Posts: n/a
Default Creating a drop down list from another drop down

I am new to the site so if I missed an answer to this question I apologize.

I have created a drop down list to show Regions example Central, East, West,
South, North. Based on the Region Selected I want to create a drop down that
will show the correct states for example if I select South I want the next
drop down to display only TX, LA, and MS, If I were to select West I would
want only CA, OR, WA. How can I do this? Thanks.