Private Sub ListCtrl_Click()
Dim valcode As String
val_code = Worksheets("Outil Mineur").Range("J2").Value
Worksheets("Outil Mineur").Activate
Application.EnableEvents = False
Application.ScreenUpdating = False
ActiveSheet.Range("$A$19").AutoFilter Field:=8
ActiveSheet.Range("$A$19").AutoFilter Field:=5, Criteria1:="CRA"
ActiveSheet.Range("$A$19").AutoFilter Field:=9, Criteria1:=val_code
Application.EnableEvents = True
Application.ScreenUpdating = True
ActiveSheet.Range("A1").Select
End Sub