This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello everyone!
Want to ask EXCEL drop-down menu questions,
At present, there are two layers of drop-down menus.
The second layer selects the list according to the conditions selected in the first layer. The current problem is that if you go back to the first layer to modify the selected list, if you do not do the second layer selection, the input fields in the second layer will not be displayed. It will not change. You need to press the pull-down menu to reselect it to pop up. I would like to ask if there is a way to make the second layer blank when the first layer is modified?
Also please experts to answer, thank you.
Hi @
It seems you're looking for the dependent dropdown list:
https://exceljet.net/dependent-dropdown-lists
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Refer to this support article about how to make dependent dropdown list, just checking in to see if the information was helpful. If anything is unclear with the information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hello, thank you for your reply, I read the content carefully, it seems that there is no mention that when the first level field is modified, the original field on the second level will be automatically reset and become blank. At this stage, the first-order linkage has been completed. To the drop-down menu of the second order, the problem is that when I go back to modify the first order, I hope that the second order can automatically clear the fields that have been filled in, thank you.
If the first layer is modified and the second layer is not reset and becomes blank, it may cause the data of the second layer to be pulled down again without attention, resulting in a field error.
Hi @Bobo ,
You can try to enter the code to Excel:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 2 And Target.Validation.Type = 3 Then
Target.Offset(0, 1).Value = ""
End If
Application.EnableEvents = True
End Sub
You need to change the Target.Column = 2, the number 2 is the column number contains the parent drop down list.
In the example my parent drop down list locates in column B:
Hope it's helpful.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Dear @Emi Zhang-MSFT
Thank you very much for your reply!I try to use the method you provided can achieve a second order reset!!
But a new problem arises.
When I try to enter a value in the third column or delete the values in the first and second columns at the same time, the "1004" error message will appear.
Do you know how to solve this problem?Thank you!
