I want to create a data validation drop down list using VBA which would reference a single cell in Excel and in that cell is a list that goes something like BGT, FOO, HR, IT. The list is a list of unit codes that each user will have access too and the list changes based on the user access and each user could have access to nothing, 1 unit, or any number of units but I just want the data validation to always read the list in the cell that I point it to. Is this possible in VBA?