Finalement j'ai trouvé la solution merci a vous je vous joins le code
Private Sub CommandButton2_Click()
Dim t As Integer
L = Worksheets("Fiche Famille").Range("A65536").End(xlUp).Row + 1
aj = ajoutmf.ListIndex + 4
f = Cells(aj, 19)
q = (Cells(aj, 19).Value * 3 - 1)
For t = L To f - 1
Worksheets("Fiche Famille").Cells(t, 1) = ajoutmf
For k = 1 To q
Worksheets("Fiche Famille").Cells(t, 1) = ajoutmf
Worksheets("Fiche Famille").Cells(t, 2) = Me.Controls("TextBox" & k).Value
Worksheets("Fiche Famille").Cells(t, 3) = Me.Controls("TextBox" & k + 1).Value
Worksheets("Fiche Famille").Cells(t, 4) = Me.Controls("TextBox" & k + 2).Value
Worksheets("Fiche Famille").Cells(t, 6) = Me.Controls("TextBox" & k + 3).Value
k = k + 3
t = t + 1
Next
Next
End Sub