Supprimer les vides dans un list de Combobox

Hello,

Y a til une solution pour supprimer la ligne vide ?

Merci pour votre aide
Meilleures salutations

Code:

---

1 2 3 4 5 6 7 8 9

Tech_A = "Claude" If Me.Textbox_Tech_1 = "Claude" Then Tech_A = "" Tech_B = "Alexis" If Me.Textbox_Tech_1 = "Alexis" Then Tech_B = "" Tech_C = "José" If Me.Textbox_Tech_1 = "José" Then Tech_C = "" Tech_D = "Henry" If Me.Textbox_Tech_1 = "Henry" Then Tech_D = "" Me.ComboBox_Tech_2.List = Array(Tech_A, Tech_B, Tech_C, Tech_D)

---

Hello,

Une solution ...

Code:

---

1 2 3 4 5 6 7 8

Tech_A = "Claude" Tech_B = "Alexis" Tech_C = "José" Tech_D = "Henry" If Me.Textbox_Tech_1 = "Claude" Then Me.ComboBox_Tech_2.List = Array(Tech_B, Tech_C, Tech_D) If Me.Textbox_Tech_1 = "Alexis" Then Me.ComboBox_Tech_2.List = Array(Tech_A, Tech_C, Tech_D) If Me.Textbox_Tech_1 = "José" Then Me.ComboBox_Tech_2.List = Array(Tech_A, Tech_B, Tech_D) If Me.Textbox_Tech_1 = "Henry" Then Me.ComboBox_Tech_2.List = Array(Tech_A, Tech_B, Tech_C)

---

Bonne soirée