I was wondering if there was a way in VBA to create a data validation dropdown list based on the items in a collection. Basically, what I have done is searched a database for a column header, selected items in that column, filtered out the unique values, and added those values to a collection...