Private Sub CommandButton3_Click()
Dim i As Byte
With ComboBox1
For i = 1 To 85
Sheets("Bdd").Cells(.List(.ListIndex, 1), i) = Controls("TextBox" & i)
Sheets("Bdd FIA").Cells(.List(.ListIndex, 1), i) = Controls("TextBox" & i)
Controls("TextBox" & i) = ""
Next i
.ListIndex = -1
End With
End Sub