Sub Macro4()
Dim x, y, cpt As Integer
cpt = 1
With Sheets("FEUIL1")
For x = 1 To 8 ' Nombre de Lignes 9, 10, 11, 12 Ect (Pour une Ligne = 3 TextBox)
For y = 1 To 3
UserForm1.Controls("Textbox" & cpt).Value = .Range(.Cells(x + 1, y), .Cells(x + 1, y)).Value
Debug.Print UserForm1.Controls("Textbox" & cpt).Value
cpt = cpt + 1
Next y
Next x
End With
x = Empty: y = Empty: cpt = Empty
End Sub