Bonsoir,
Voici votre code, indenté :
Private Sub UserForm_Initialize()
Dim i As Long
Dim k As Long
With usf_rens.Cb_civilité
.List = Array("Monsieur", "Madame", "Mademoiselle")
End With
cb_sexe.List = Array("M", "F")
With Sheets("bd2")
i = .Range("A" & Rows.Count).End(xlDown).Row
For k = 2 To i
cb_spécialité.AddItem .Range("A" & k).Value
Next k
End With
End Sub
remplacez : i = .Range("A" & Rows.Count).End(xlDown).Row
par i = .Range("A" & Rows.Count).End(xlUp).Row
Cela devrait être mieux...