02-03-2023, 09:28 AM
|
Novice
|
|
Join Date: Jan 2023
Posts: 2
|
|
Multi Dependent Lists with Same Options
Quote:
Originally Posted by macropod
Adding more levels of dependent dropdowns is really just a case of extending the logic. See attached.
The 'A' example extends the logic to two dependencies. The content controls in this code are titled 'Master', 'Servant' and 'Slave'. You can use other titles, provided you make the corresponding changes to the VBA code.
The 'B' example makes it simpler to add multiple additional dependencies. Being more generalized, the 'B' code requires you to specify how many levels there are - see note at the top of the VBA code. The content controls in this code are titled 'Level 0' through 'Level 3'. You can change 'Level' to any other single word without changing the VBA code. A space must remain between the text and level number, however.
|
I am attempting to create an audit tool. The example B you provided has been very helpful. However, how would I be able to repeat these dependent dropdowns throughout the same document. For example, when auditing a health assessment, there are 11 different functional items that may have to be documented for different incorrect subsections which all have the same options list. Any advice you could provide would be GREATLY appreciated
|