Forum Discussion
PapaAustin
Jan 04, 2022Copper Contributor
How To Create Multi Level Dependent Drop Down List In Excel?
Hello Excel Community, I am looking to create a multi level drop down menu. Below is an example of what i am looking to create. https://www.extendoffice.com/documents/excel/5852-excel-multiple-le...
HansVogelaar
Jan 04, 2022MVP
PapaAustin
Jan 05, 2022Copper Contributor
Thanks! The link was very helpful.
Is there a way to make lower tier drop down menus with a first value of the options?
In my GIF example, if America is selected from the continents, then Canada would be auto-populated.
Is there a way to make lower tier drop down menus with a first value of the options?
In my GIF example, if America is selected from the continents, then Canada would be auto-populated.
- HansVogelaarJan 05, 2022MVP
That would require VBA. Would that be acceptable?