Context Sensitive Drop Down Menus

S

Sam Bench

I need to be able to specify drop down menus that depend on the selections
made in other menus. For example, I will specify in cell A1 the choice
between dog and tree. If the user picks dog then I want the selections in
cell B1 to be beagle and hound. If the user picks tree in A1 then I want
the choices in B1 to be oak and pine. I think you get my drift. It isn't
clear to me how to set this up. Any help would be appreciated. Thanks in
advance.
 

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

Drop down list control value in vba 2
Data Validation and drop-down list using IF, AND and what else? 8
Using a drop-down box to sort data based on seperate columns 2
Drop Down Menus 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Drop down menus based on selection of a previous menu? 0
Drop Downs, Index Match or what? 56
Using VBA to change the contextual menus 3

Top