Modyifying code or new to delete duplicate items in others comboboxes based on combobox

[Alaa-A]

Hello
I want adjusting this jindon's code or new whatever . what I look for when I select the item from first combobox then shouldn't show the the same item in the others comboboxes , for instance if I select item ATR-100 from combobox1 then should not show in others comboboxes and and if I select item ATR-101 from combobox2 then should not show in comboboxes 1,3,4 . so when select the item from specific combobox shouldn't show in the others comboboxes .
thanks

[beyond Excel]

Hello.
Please see if this works for you:

Private Sub GetMatch(cb As MSForms.ComboBox)
Dim N$
D2.RemoveAll
For Each cbTmp In D1.Keys
  D2(cbTmp) = D1(cbTmp)
Next
For Each cbTmp In myCB
  If cbTmp <> "" Then D2.Remove cbTmp.Value
Next
For Each cbTmp In myCB
  cbTmp.Column = Application.Transpose(D2.Items)
  If cbTmp.Value <> "" Then
    cbTmp.AddItem D1(cbTmp.Value)(0), 0: cbTmp.List(0, 1) = D1(cbTmp.Value)(1)
  End If
Next
With cb
  N = Right(cb.Name, 1)
  If .ListIndex > -1 Then
    Controls("TextBox" & N) = .List(.ListIndex, 1)
  Else
    Controls("TextBox" & N) = ""
  End If
End With
End Sub 

[Alaa-A]

great ! this is what I look for but I face error application defined or object deifined error when right item in combobox instead of selection in this line

D2.Remove cbTmp.Value

if it's possible when right wrong item then should show message "is not matched"
thanks again

[beyond Excel]

great ! this is what I look for but I face error application defined or object deifined error when right item in combobox instead of selection in this line

D2.Remove cbTmp.Value

So let's prevent this from happening:

[Alaa-A]

all of things are ok !
can you tell me what's the procedure you added to avoid error?
actually I don't note it .

[beyond Excel]

Don't forget to add reputation to the answer that helped you.

[Alaa-A]

Don't forget to add reputation to the answer that helped you.

actually I really did it , but as you know , not always allow so . this time I can't sorry !
even if that thanks so much for your help