Reset a Linked Combo Box Selection Automatically in Excel
Question details
Automatically reset a dependent combo box selection when a Form Control combo box changes.

- 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.
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.
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.
In desktop Excel, open the workbook, press Alt+F11, and choose Insert > Module in the VBA editor.
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.
Return to the worksheet, right-click the first Form Control combo box, choose Assign Macro, select ResetDependentCombo, and click OK.
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.

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.

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.




