Avoiding two or more comboboxes having same selection at a time vba

[kelly mort]

I have five comboboxes in all.

One named cmbMain

The other four, cmb1 to cmb4

CmbMain is loaded with five items.

When I select the first item from cmbMain, I enable only cmb1.
When I select the second item, I enable both cmb1 and cmb2.
When I select the third and fourth items, I enable cmb1, cmb2 and cmb3.
When I select the fifth item, I enable all from cmb1 to cmb4.

Cmb1 to cmb4 are loaded with same items, say A, B, C, D.

My goal is to be able to avoid selecting same item in multiple comboboxes.

Can someone pull it up for me?

I can't seem to figure it out.

 

[jasonb75]

Assuming that your comboboxes are in a userform, try something like this to populate the list in Cmb2 after a selection has been made in Cmb1, then use similar for the remaining boxes.

Private Sub Cmb1_Change()
With UserForm1
    .Cmb2.List = .Cmb1.List
    .Cmb2.RemoveItem (.Cmb1.ListIndex)
End With
End Sub

You will need to add a logical test to exit without populating if the box is not enabled.

 

[kelly mort]

Assuming that your comboboxes are in a userform, try something like this to populate the list in Cmb2 after a selection has been made in Cmb1, then use similar for the remaining boxes.

Private Sub Cmb1_Change()
With UserForm1
    .Cmb2.List = .Cmb1.List
    .Cmb2.RemoveItem (.Cmb1.ListIndex)
End With
End Sub

You will need to add a logical test to exit without populating if the box is not enabled.

Okay. Got it, loud and clear.

I really appreciate that.

Have a nice time