Bonjour,
Le code en ayant supprimé les RechercheV() :
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Plage As Range
Dim Cel As Range
Dim I As Integer
If Target.Count > 1 Then Exit Sub
If Target.Column > 1 Then Exit Sub
With Worksheets("Feuil2")
Set Plage = .Range(.Cells(2, 1), .Cells(.Rows.Count, 1).End(xlUp))
Set Cel = Plage.Find(Target.Value, , xlValues, xlWhole)
If Not Cel Is Nothing Then
Application.EnableEvents = False
Range(Target.Offset(, 1), Target.Offset(, 5)).Value = ""
Target.Offset(, 1).Value = Cel.Offset(, 1).Value
Target.Offset(, 2).Value = Cel.Offset(, 11).Value
Target.Offset(, 3).Value = Cel.Offset(, 4).Value
Target.Offset(, 4).Value = Cel.Offset(, 3).Value
Target.Offset(, 5).Value = Cel.Offset(, 10).Value
Application.EnableEvents = True
Range(Target.Offset(, 1), Target.Offset(, 5)).Font.Bold = False
Target.Offset(, 2).Interior.Color = Cel.Offset(, 11).Interior.Color
For I = 1 To Len(Cel.Offset(, 10).Value)
Target.Offset(, 5).Characters(I, 1).Font.Bold = Cel.Offset(, 10).Characters(I, 1).Font.Bold
Next I
End If
End With
End Sub