Reset Combo boxes when reselecting first one

[Grimm127]

Hi All you Excel Guru's

I need a little help. I am using four combo boxes from the Data Ribbon (Controls - Insert - Format Controls Combo Box (From Control).

I would like to set it up that when the 1st combobox changes its selection that the other three reset. Do any of you have any ideas or suggestions that may be of some use for me. All four boxes have a cell link that gets populated based on the row selection. those cell links are then attached to other formulas

Thank you all in advance and I really appreciate the help.

Regards,​

 

[MickG]

Do you mean (Form Control) not (From Control)
and therefore assume these are "Forms" controls and not "ActiveX"

 

[Grimm127]

**** you SpellCheck! LOL
Yes, you are 100% correct on both. Form Control and not Active X

 

[MickG]

Try This, I'm assuming by "Reset" you mean for all Drop Downs to appear Blank, except the one that Has focus.:-


Place this code in a Basic Module:-

Sub DDset()
Dim DD As DropDown
For Each DD In ActiveSheet.DropDowns
    If Not DD.Name = Application.Caller Then
       DD.ListIndex = 0
    End If
 Next DD
End Sub

For each of the "DropDowns" do the following:-
Right Click the first Drop Down Box, Dialog box appears,select Click "Assign Macro"
Assign Macro Dialog box appears,
In the list of "Code names" you should see, "DDset", click on it, this should then appear in the top slot in the dialog box.
Now click "Ok".
Repeat this operation for each Dialog box

To test select value from any "Drop Down",
Then select a value from another drop down.
The first drop down should now be blank.