Using same dropdown list several times

Question

Hello,

I'm making a form in MS Word where I have to allocate personnel to 5 different zones. To each of these zones I must assign one of 6 operatives. I have made a dropdown list containing the names of those 6 people to choose from for Zone 1.

For each of the remaining zones I have had to copy the same dropdown list from the first.

However, should there be a change in personnel, I would have to go through the properties of each of the 5 dropdown lists to amend the names.

Is there a method that allows for one dropdown list to be modified which takes affect in all others?

(And perhaps, although not necessary, once a name is chose in one of the zones, it is thus unavailable for selection in the others, since that person has been assigned)

Any guidance would be most appreciated.

John Hamlyn

Answer 1

It is simple enough to use VBA to update a series of dropdown content controls so they all have the same options. Beyond that, for:

Dependent Dropdown Content Controls, see -

https://www.msofficeforums.com/word-vba/24661-help-cascading-dropdown-list.html#post77762

and, for multiple levels of dependency:

https://www.msofficeforums.com/word-vba/24661-help-cascading-dropdown-list.html#post132696

Cascading Dropdown Content Controls, see -

https://www.msofficeforums.com/word-vba/29617-creating-reducing-drop-down-list.html#post94603

Dependent Text Content Controls. see -

https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists.html#post46903

and, for different elements from a selected item to be output to different content controls, see:

https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists-5.html#post120392