PDA

View Full Version : Validation list from multiple dynamic ranges



Metheny
06-14-2011, 10:58 AM
I'm pretty new to VBA, and I've already read how to bind a validation list to a dynamic range.

Now, what I have are a few dynamic ranges (on different sheets), which I need to bind to a single validation list (i.e. values from all ranges should appear in the validation list).

Is this possible?

Thanks!

mancubus
06-15-2011, 02:53 AM
afaik, you cannot combine multiple ranges for use in data validation.

create a new ranges copying values from your dynamic ranges.

Metheny
06-15-2011, 03:20 AM
Yes, that's what I did eventually.
I created an invisible sheet with the complete list, and handled the change event of the original sheets by updating the invisible sheet.

Thanks for the help :-)