Private Sub CommandButton1_Click()
Dim b As Range
Sheets("Feuil1").Activate
With Range([A1], Sheets("Feuil1").[XFD1].End(xlToLeft))
Set b = .Find(ComboBox1.Value, LookIn:=xlValues)
'b.Activate
col = b.Column
Cells(Rows.Count, col).End(xlUp).Offset(1, 0) = ComboBox2.Value
End With
End Sub