Document Editing Problems

How to Use One Shared Drop-Down List in a Word Form

Anum Mushtaq Oct 15, 2026 870 views

Question details

The user needs to synchronize multiple drop-down lists in a Word form so they share the same entries or prevent duplicate selections across different zones.

How to Create a Shared Drop-Down List in a Word Form

Product: Word
Device & OS: not provided
Scenario: Creating a dynamic document form where updating one drop-down list automatically updates others, or where selecting an option removes it from subsequent lists.
Observed behavior: Native Word content-control drop-down lists do not automatically share entries or sync with each other, requiring manual updates for each individual control.

Before you start

Ensure that the Developer tab is enabled in your Word ribbon, and remember to save your document as a Macro-Enabled Document (.docm) since this solution requires VBA code.

Solution 1Recommended

Use VBA to Sync Drop-Down Content Controls

Utilize VBA macros to link multiple drop-down content controls to a central list or create dependent/cascading lists.

Because Word does not natively link separate drop-down controls, VBA (Visual Basic for Applications) must be used to automate the process. A macro can be written to trigger whenever a user exits a drop-down list, automatically updating the available options in the remaining lists.

Enable the Developer Tab

Go to File > Options > Customize Ribbon and check the box next to 'Developer' in the right pane, then click OK.

Insert Drop-Down Controls

Click the Developer tab and use the Controls group to insert 'Drop-Down List Content Controls' into your document. Click 'Properties' to assign each control a unique Title and Tag.

Open the VBA Editor

Click the 'Visual Basic' button in the Developer tab to open the VBA editor.

Add the Automation Code

In the left pane, double-click 'ThisDocument' and paste or write a macro script utilizing the Document_ContentControlOnExit event. This script will dictate how the other drop-down lists behave (e.g., removing a selected name from other zones) based on the user's input.

Save as Macro-Enabled Document

Go to File > Save As, and choose 'Word Macro-Enabled Document (*.docm)' from the format dropdown so your VBA code functions properly when reopened.

Use VBA to Sync Drop-Down Content Controls

Advanced VBA Logic: Creating reducing drop-down lists (where a selected person is removed from other zones) requires advanced VBA logic to iterate through controls and rebuild the list options dynamically. You can find pre-written cascading drop-down scripts in dedicated Office macro forums.

Advanced Form Automation

Create Dynamic Forms with WPS Writer

WPS Office provides comprehensive support for document form fields, content controls, and VBA macros in its professional version, allowing you to build dynamic and automated documents easily.

1. Access the Developer Tools: Open WPS Writer, navigate to the top ribbon, and click on the Developer tab to access macro and form tools.
2. Insert Form Controls: Use the Drop-Down Form Field option to insert selectors directly into your document zones.
3. Write the Sync Macro: Click 'Macros' or the 'Visual Basic' editor icon to insert your custom VBA script for linking the drop-downs.
4. Save and Share: Save your form as a macro-enabled file, ensuring the automation works smoothly for anyone filling out the document.

Fully compatible with Microsoft Word document formats (.docx, .docm).Supports advanced VBA macros for automating form controls and shared lists.Lightweight, fast, and features an intuitive tabbed interface for easier multitasking.

microsoft office alternative - wps office

Frequently Asked Questions

Why aren't my drop-down lists updating automatically in Word?

Word does not have a built-in feature to automatically sync separate drop-down content controls. You must use VBA macros to push updates or changes from one control to another.

What is a cascading drop-down list?

A cascading (or dependent) drop-down list is one where the options available depend entirely on the selection made in a previous drop-down list.

Can I prevent a user from selecting the same option twice in a Word form?

Yes, but this requires a custom VBA script that triggers when a selection is made, dynamically removing that chosen option from the remaining drop-down lists in the document.

Will macros run automatically when someone opens the form?

Macros will only run if the document is saved as a Macro-Enabled Document (.docm) and the user chooses to 'Enable Content' when prompted by their security settings upon opening the file.

Document & File Issues