JosephALin
New Member
- Joined
- May 13, 2016
- Messages
- 13
Hi! I am very new to Excel VBA. Please help me figure out how to build nested data validation drop down lists.
I do know how to build hierarchical data validation lists. The current situation is I have three drop down lists called committees, membership categories and companies, under each headers I have multiple items that will summon out different contents to be printed on the worksheet using macros. And now I need to sort of link them all together, in order to achieve the result where I could use these three drop down lists like the filters in the master database. There should be no order necessary when it comes the three header, any one of them could be the first one to be chosen, and under the chosen content I can use other two lists to generate sub-content.
I have no idea whether this could be solved by VBA code in the workbook or within data validation function, so I will not leave any code down here, sorry.
Thank you guys so much!
I do know how to build hierarchical data validation lists. The current situation is I have three drop down lists called committees, membership categories and companies, under each headers I have multiple items that will summon out different contents to be printed on the worksheet using macros. And now I need to sort of link them all together, in order to achieve the result where I could use these three drop down lists like the filters in the master database. There should be no order necessary when it comes the three header, any one of them could be the first one to be chosen, and under the chosen content I can use other two lists to generate sub-content.
I have no idea whether this could be solved by VBA code in the workbook or within data validation function, so I will not leave any code down here, sorry.
Thank you guys so much!
