I used to be questioning whether it is doable to solely present objects in an information validation record primarily based on situation(s)?
Like for instance, if I enter AAA on cell A1, the information validation record in cll B1 will solely present the named vary AAA which incorporates 1,2,three or if I select the named vary BBB and I enter BBB on cell A1, the information validation record in cell B1 will solely present the named vary BBB which incorporates 4,5,6?
The catch right here is the strings which might be being written in cell A1 is dynamic. Like for instance as we speak I’ve 50 choices to place in cell A1 all of which have their very own named ranges to point out within the knowledge validation record in cell B1, then tomorrow it will possibly solely have 20 choices.
Additionally, the variety of objects in these named ranges range as nicely.
I additionally posted right here the place I’m able to connect a pattern file: http://www.vbaexpress.com/discussion board/showthread.php?67237-Knowledge-Validation-based-on-Situation(s)-in-Excel-VBA&p=401358#publish401358