VBA for Dynamic Dependent Drop Down Data Validation Lists

Dead easy.

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

if range("A1").value = "whatever" then


end if

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.