Private Sub UserForm_Initialize()
Dim Plage As Range
With Worksheets("FSEx 2014")
Set Site1 = .Range("A2")
Set Plage = .Range(Site1, .Range("A65536").End(xlUp))
Set Tableau = Plage.Resize(, 25) '<---------------------- j'adapte le tableau ???
End With
ComboBox1.List = Plage.Value
If TextBox7.Value <> "" Then
TextBox10.Value = Feuil1.Cells(ComboBox1.ListIndex + 2, 15)
End If
End Sub