il me faudrait un formulaire qui me met au bon endroit
For j = 1 To 3
col = Choose(j, 3, 5, 4)
f.Cells(lgn, col) = Val(Replace(Controls("TextBox" & j + 2), ",", "."))
Next j
f.Cells(lgn, 9) = TextBox2
If TextBox6 <> "" Then
f.Cells(lgn, 8) = Val(TextBox6)
End If