ANmarS - Portfolio - Multi-Validations

Excel/VBA expert since Sep 1997 (21 years 3 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

Multi-Validations    Added: 1/15/2012 | Created: 5/14/2009   

Having a Validation that depends on another validation, meaning when you first select an item from first validation, the validation connects to it will show its sub validation.
In another word, once you select an item from drop-down, the connected drop-down list sub items of the selected one. Does that make sense?
Not only that, we actually have multiple dual validations, you might need to visit the lesson Doing Validation based on another Validation to see how to created it.

The zip also contains a version (Multi_Validation_Reset) that has macro to reset the second validation if first validation is changed.

Download (16.8 KB)

1205 downloads | Last updated: 1/15/2014

Screen shots (8)