See the attached. The update process for the second dropdown is controlled by a ContentControlOnExit macro, which you can see by pressing Alt-F11. The conditional text for each dependent option is held as comma-delimited strings in the 'StrOut' variable populated by the 'Select Case' statement.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|