Bonjour,
Je n'ai modifié que ces deux macros ... le reste semble en ordre ...
Private Sub Bt1_Click()
Dim n&
With Feuil8
If L1.ListIndex = -1 Then
fin = .Range("A" & Rows.Count).End(xlUp).Row + 1
For i = 2 To 12
If IsNumeric(Controls("T" & i)) Then .Cells(fin, i - 1) = CDbl(Controls("T" & i)) Else .Cells(fin, i - 1) = Controls("T" & i)
Next i
Else
For i = 2 To 12
If IsNumeric(Controls("T" & i)) Then .Cells(lig, i - 1) = CDbl(Controls("T" & i)) Else .Cells(lig, i - 1) = Controls("T" & i)
Next i
End If
End With
Unload Me
End Sub
Private Sub L1_Click()
Dim n&
If L1.ListIndex = -1 Then Bt1.Caption = "Ajouter": Exit Sub
n = 2
With Feuil8
lig = L1.List(L1.ListIndex, 11)
For i = 1 To 11
Controls("T" & i + 1) = .Cells(lig, i)
Next i
End With
Bt1.Caption = "Modifier"
End Sub
ric