VBA to reveal Validation Options

  • I'm working in a file that has a bunch of Validation Lists, but most are not tied to a range and are - instead - comma separated lists (facepalm)


    What I'd really love is a way to reveal the validation lists (CSL) in an adjacent sent... but coding and I are not great friends.


    Something like...


    IF Cell B2 contains a Validation List, a formula could show me that the Data Validation List contains "Apples, Oranges, Bananas, Kumquats"... all available options


    Seems like this would be doable, but I'm not sure how to translate Evaluate(Range.Validation.Formula1) into a workable object that I could then reference on a cell by cell basis.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!