Two Data validation selections second is dynamic based on first

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
179
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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

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