Private Sub ComboBox1_Change()
Dim rng As Range
Set rng = Sheets("BdD Projets").Range("B:B")
i = Application.Match(CLng(ComboBox1), rng, 0)
TextBox1 = ComboBox1 & " est en : ligne N° " & i
End Sub
Private Sub UserForm_Initialize()
ComboBox1.List = Array(1, 2, 3, 4, 5, 6)
End Sub