Bonsoir,
Tu remplaces le code du Combobox13 par celui-ci
Private Sub ComboBox13_Change()
Dim L As Integer 'Déclaration de variable "L" pour connaitre la Ligne Numéro
L = Sheets("stockes").[A:A].Find(ComboBox13, LookIn:=xlValues).Row
Me.TextBox11 = Sheets("stockes").Cells(L, 4)
Me.TextBox14 = Sheets("stockes").Cells(L, 2)
Me.TextBox15 = Sheets("stockes").Cells(L, 3)
Me.TextBox16 = Sheets("stockes").Cells(L, 5)
Me.TextBox17 = Sheets("stockes").Cells(L, 6)
Me.TextBox18 = Sheets("stockes").Cells(L, 7)
Me.TextBox13 = Sheets("stockes").Cells(L, 11)
Me.TextBox12 = Sheets("stockes").Cells(L, 10)
End Sub
et le CommandButton9 par celui-ci
Private Sub CommandButton9_Click()
With Sheets("stockes")
L = Sheets("stockes").[A:A].Find(ComboBox13, LookIn:=xlValues).Row
.Range("d" & L).Value = TextBox11.Value
.Range("b" & L).Value = TextBox14.Value
.Range("c" & L).Value = TextBox15.Value
.Range("E" & L).Value = TextBox16.Value
.Range("F" & L).Value = TextBox17.Value
.Range("G" & L).Value = TextBox18.Value
.Range("j" & L).Value = TextBox13.Value
.Range("k" & L).Value = TextBox12.Value
End With
ComboBox13 = ""
TextBox11 = ""
TextBox12 = ""
TextBox13 = ""
TextBox14 = ""
TextBox15 = ""
TextBox16 = ""
TextBox17 = ""
TextBox18 = ""
'permet de saisir et de laisser la fenétre active
Dim c As Control
For Each c In Me.Controls
Select Case TypeName(c)
Case "TextBox"
c.Value = ""
Case "ComboBox"
c.Value = ""
End Select
Next c
End Sub
Henri