VBA for Dynamic Dependent Drop Down Data Validation Lists

Hello!

Does anyone know a way of creating dynamic/dependant drop down data validation lists with vba? E.g a data validation list in one cell will differ depending on what is in another cell.

I know this is possible with formulas and source tables etc. but I really want to avoid cluttering my workbook with source tables - i'd like it to all work behind the scenes with code!

I'd really appreciate any help or suggestions!

Thanks!

Dead easy.

Lets say you're using a specific cell value to define contents of the drop down. Access that cell by:

Please Login or Register  to view this content.

In between the if and end if is where you define the contents of your dropdown. Look here for a detailed example:
https://trumpexcel.com/extract-data-...rop-down-list/

Hello! Thanks for your reply. Although this article refers to extracting data from data validation lists, not how to create dynamic data validation lists so won't work for me.