VBA & Macro Problems

Reset a Linked Combo Box Selection Automatically in Excel

Khadija KhanKhadija Khan Nov 20, 2026 869 views

Question details

Automatically reset a dependent combo box selection when a Form Control combo box changes.

Reset a Linked Combo Box Selection Automatically in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A basket selection in one Form Control combo box determines the selection in a second combo box linked to a worksheet cell.
Observed behavior
Changing the first combo box updates its linked cell but does not reliably trigger Worksheet_Change, so the dependent linked cell is not reset.
Before you start

Identify the first combo box, the dependent combo box's linked cell, and the name of the worksheet containing that cell. Confirm that the dependent combo box has at least one item, since the reset value of 1 selects its first item.

Solution 1Recommended

Assign a Macro to the First Form Control Combo Box

Use the combo box's assigned macro to reset the dependent linked cell without relying on Worksheet_Change.

1
Open the VBA editor

In desktop Excel, open the workbook, press Alt+F11, and choose Insert > Module in the VBA editor.

2
Add the reset macro

Paste this code into the module: Sub ResetDependentCombo() ThisWorkbook.Worksheets("Sheet1").Range("D9").Value = 1 End Sub. Replace Sheet1 with the worksheet name and D9 with the dependent combo box's linked cell.

3
Assign the macro

Return to the worksheet, right-click the first Form Control combo box, choose Assign Macro, select ResetDependentCombo, and click OK.

4
Save and test

Use File > Save As to save the workbook as an Excel Macro-Enabled Workbook (.xlsm). Enable macros if prompted and trusted, then change the first combo box selection and check that the dependent combo box selects its first item.

Assign a Macro to the First Form Control Combo Box
Check the linked cell: Right-click the dependent combo box and choose Format Control > Control to verify its cell link. A Form Control combo box stores the selected item's position in that cell, so 1 means the first item.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday spreadsheet work. Review form controls and macros when migrating, as Excel-specific automation may behave differently.

Edit spreadsheets in a familiar, easy-to-use interfaceOpen and save common Microsoft Excel formats, including XLSX and XLSWork with worksheet cells and selection data used in dependent listsUse a lightweight office suite for everyday document tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Worksheet_Change run when I select an item?

A Form Control combo box can update its linked cell without reliably firing Worksheet_Change. Right-click the combo box and use Assign Macro to run a reset procedure when its selection changes.

How do I find the dependent combo box's linked cell?

Right-click the dependent Form Control combo box, choose Format Control, and open the Control tab. Check the Cell link field and use that address in the macro.

Why does the macro set the linked cell to 1?

A Form Control combo box uses its linked cell to store the position of the selected item. Setting the cell to 1 selects the first item, provided the input list is not empty.

Can I use an ActiveX combo box instead?

Where ActiveX controls are supported and enabled, you can use an ActiveX combo box and place reset code in its Change event. Check your Excel version and security settings before relying on ActiveX.