Private Sub ComboBox1_Change()
If ComboBox1 <> "" Then
Call Changer
Else
Exit Sub
End If
End Sub
Private Sub Changer()
If ComboBox1 = "OUI" Then
ComboBox2.ListFillRange = "Choix!$D$9:$D$12"
Else
ComboBox2.ListFillRange = "Choix!$D$13:$D$16"
End If
End Sub