Macro to populate multiple validation lists, based upon user's selection

[katie.rader]

I have a worksheet that will allow a user to select form numbers for up to 15 different forms. I have one routine populate the form list based upon if the form has rules or not.
I use the selected form number to populate three fields: type, name, id.
Each form may have multiple rules I wish to create multiple validation lists based upon the form number selected. One list will need to contain the Rule# that corresponds to the form number, the next list will need to contain the variable which corresponds to the rule# and the next list will need to contain the value which corresponds to the variable, and final list will need to contain the required list corresponding to the value.

I have multiple macros that will populate this data however I don't think it is very efficient the way it is working now. The part I am struggling with is that I wanted to create subroutines for each form# to populate all of the desired fields. I started this piece with the SubVariable in the attached doc.



Can someone please help?

Thanks in advanced.
Katie

[Winon]

Hello katie.rader,

Welcome to the Forum.

Please take a moment to revisit the Forum Rules again, and in particular the section which explains wrapping of any Code.

See this link for Dependent Validtation Lists, it should give you a good start.

http://www.contextures.com/xlDataVal02.html

[katie.rader]

Thank you for the website and I had already stumbled onto it prior to posting. I do have my validation lists and formulas working the piece I was struggling with was getting the code into VBA. My document is used many times however it may contain completely different data. There are three sheets that are used for this workflow- one contains the forms, one contains the rules and the third I attached a screenshot of how it appears to display the data. Ultimately I would like to not have the forms and rules tabs displaying (which I have set already). Any help is greatly appreciated.

Please Login or Register  to view this content.