Bonjour Teddy, bonjour le forum,
Essaie comme ça. Remplace ton code par celui-ci :
Private Sub UserForm_Initialize()
Dim aa
C1.ColumnCount = 2
C1.ColumnWidths = ";0"
With Feuil2
aa = .Range("A2:B" & .Range("A" & Rows.Count).End(xlUp).Row)
End With
C1.List = aa
End Sub
Private Sub C1_Change()
Dim i&
For i = 1 To 1
Controls("T" & i) = C1.List(C1.ListIndex, i)
Next i
End Sub
Private Sub CommandButton1_Click()
Dim LI As Integer
Dim COL As Byte
Select Case T1.Value
Case "machin"
COL = 2
Case "truc"
COL = 3
Case "bidule"
COL = 4
End Select
LI = CInt(C1.ListIndex + 2)
Feuil1.Cells(LI, COL).Value = Me.TextBox2.Value
End Sub