Formatting Issues

How to Color Word Table Cells Based on Drop-Down Selection Using VBA

Steven Parker Oct 20, 2026 868 views

Question details

The user needs a method to dynamically change the background color of a table cell depending on the specific text option selected from a drop-down list inside that cell.

Color a Word Table Cell Based on a Drop-Down Selection Using VBA

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating dynamic forms or status trackers where visual color-coding is required based on user selection.
Observed behavior: The table cell background color will automatically update to predefined colors (like orange, yellow, or green) upon exiting the drop-down control based on the chosen value.

Before you start

Ensure your document is saved as a Macro-Enabled Document (.docm) and that the Developer tab is enabled on your ribbon to access Content Controls and the VBA Editor.

Solution 1Recommended

Use Document_ContentControlOnExit Event by Tag

Assign a specific tag to your drop-down content control and use a VBA macro to trigger a color change when the user exits the control.

This method uses the built-in Document_ContentControlOnExit event, which fires automatically when a user clicks outside a content control. By verifying the control's Tag property, you ensure the script only applies formatting to the intended drop-down menus.

Insert and configure the Content Control

Go to the Developer tab, insert a Drop-Down List Content Control into your table cell. Click 'Properties' in the Developer ribbon, type 'CellColor' in the Tag field, and add your drop-down choices (e.g., Beginning, Developing).

Open the VBA Editor

Press Alt + F11 to open the Visual Basic for Applications window. In the Project Explorer on the left side, double-click on 'ThisDocument' to open the document's code module.

Add the formatting VBA code

Create a Private Sub Document_ContentControlOnExit subroutine. Use an 'If ContentControl.Tag = "CellColor" Then' statement, followed by a 'Select Case ContentControl.Range.Text' block. For each case (e.g., "Beginning"), set 'ContentControl.Range.Cells(1).Shading.BackgroundPatternColor' to your desired color like 'wdColorOrange'.

Test the macro

Save your work, close the VBA editor, and return to your document. Select an option from your drop-down list, then click anywhere outside the table cell. The cell background color should immediately change.

Use Document_ContentControlOnExit Event by Tag

Event Trigger Behavior: The color change will not happen instantly when you select an item from the drop-down list. The macro executes only when you 'exit' the control by clicking outside of it or pressing the Tab key.

Solution 2

Target Content Controls by Title

Filter the VBA script execution using the Title property instead of the Tag property if your document uses titles for element management.

Advanced Document Automation

Automate Document Formatting Easily with WPS Office

WPS Office provides robust support for Developer tools and VBA macros, allowing you to create dynamic, interactive documents with automated drop-down formatting efficiently.

1. Enable Developer Tools: Open WPS Writer, navigate to the settings, and enable the Developer tab to access form fields and content controls.
2. Insert Drop-Downs: Use the Developer ribbon to insert drop-down lists into your tables and configure their tags or titles.
3. Write Custom Macros: Click the Macro Editor button to paste your VBA code, automating cell colors based on user input seamlessly.

Fully compatible with Microsoft Word macro-enabled documents (.docm)Built-in Developer tools for managing Content Controls and form fieldsIntegrated VBA Editor for writing and debugging custom macro scriptsFree, lightweight, and features a familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the cell color change immediately when I select an item from the drop-down?

The VBA event 'Document_ContentControlOnExit' only triggers when the content control loses focus. You must click outside the drop-down list or press Tab to see the background color update.

Can I use exact custom colors instead of standard VBA colors like wdColorOrange?

Yes, you can use the RGB(red, green, blue) function in your VBA code to set custom background colors. For example, assign 'RGB(255, 165, 0)' to the BackgroundPatternColor instead of 'wdColorOrange'.

Does this VBA macro work with legacy form fields?

No, this specific VBA code and event trigger are explicitly designed for Content Controls. If you are using Legacy Form Fields, you would need to write a different macro and attach it as an 'On Exit' macro within the legacy field's properties.

Document & File Issues