Bonjour,
Pour modifier ...
Un essai ...
Private Sub CommandButton3_Click() 'modifier
Dim L As Integer, C As Integer
L = Me.ListBox1.ListIndex + 5 ' +5 pour faire correspondre la ligne du listbox et la ligne de la feuille
With Sheets("opérations")
.Cells(L, 1).Value = TextBox1.Value
.Cells(L, 2).Value = CDate(TextBox2.Value)
.Cells(L, 3).Value = TextBox3.Value
.Cells(L, 4).Value = TextBox4.Value
.Cells(L, 5).Value = TextBox5.Value
.Cells(L, 6).Value = CDbl(TextBox6.Value)
.Cells(L, 7).Value = TextBox7.Value
.Cells(L, 8).Value = TextBox8.Value
.Cells(L, 9).Value = TextBox9.Value
End With
Me.ListBox1.ListIndex = -1 ' affichage vide du listbox
Me.CommandButton3.Visible = False
Me.CheckBox2 = False
ResetOptionButton
VideTextbox
End Sub
ric