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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|