Dear all,
I would like to create 3 tables, each table containing 2 word dropdown lists "Category" and "Subcategory" (see attached dotm file "
Category and Subcategory.dotm") imported from an excel (see attached excel file "
Sample Question.xlsm"). "Subcategory" dropdown list is dependent on the "Category" dropdown list. For example, if the user selects "A" under "Category", he will only see options "A1", "A2", "A3", "A4" under the "Subcategory" dropdown list. If the user selects "B" under "Category", he will only see options "B1", "B2", "B3", "B4" etc.
All the values in the word dropdown list must be imported from the excel and not hardcoded within the word document.
In addition, if the user doesn't require all 3 tables, he can choose to delete 1 or 2 or 3 tables.
Appreciate if someone could assist on the VBA codes for this.
Thanks!