Two Data validation selections second is dynamic based on first

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
180
I have two data validation dropdowns on a spreadsheet. The second is dynamic and based off the first selection.
I would like when the first cell changes to cause the second to automatically choose the first dropdown of the newly dynamic choices.
If not the user can create a combination of the two boxes that is not desired by skipping the second box and launching the code.

Can anybody help with code to capture the other cell has been changed. I believe that it is a drop down make it harder to use Changed cell technique.

As always help is greatly appreciated.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Simple example:
Book1
ABCDEF
1FruitApplesSteak
2MeatBananasHamburgerFood Section: Fruit
3PeachesLambSelect Item: Bananas
Sheet1
Cells with Data Validation
CellAllowCriteria
F2List=$A$1:$A$2
F3List=INDIRECT($F$2)

The trick is that B1:B3 is a named range Fruit, and C1:C3 is a named range Meat. Cell F2 uses A1:A2 for its drop down list, and cell F3 uses INDIRECT to select which Named Range to use for its drop down list.
That should do it!
 
Upvote 0
Solution

Forum statistics

Threads
1,223,959
Messages
6,175,647
Members
452,663
Latest member
MEMEH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top