Private Sub CommandButton1_Click()
Dim Ctrl As Control, Ligne&, I As Byte
Ligne = 1
I = 1
For Each Ctrl In Controls
If TypeOf Ctrl Is MSForms.TextBox Then
If Ctrl.Visible Then
Cells(Ligne, I) = Ctrl.Object.Value
I = I + 1
End If
End If
Next Ctrl
End Sub