Private TCBxList()
Sub UserForm_Initialize()
Me.ComboBox1.List = Feuil1.[A1:A7].Value
TCBxList = Me.ComboBox1.List
Me.ComboBox2.List = TCBxList
End Sub
Private Sub ComboBox1_Change()
RectifList
End Sub
Private Sub ComboBox2_Change()
RectifList
End Sub
Private Sub RectifList()
Dim LIx1&, LIx2&
ComboBox1.List = TCBxList: LIx1 = ComboBox1.ListIndex
ComboBox2.List = TCBxList: LIx2 = ComboBox2.ListIndex
If LIx1 >= 0 Then ComboBox2.RemoveItem LIx1
If LIx2 >= 0 Then ComboBox1.RemoveItem LIx2
End Sub