Re, bonjour toutes et tous
essai test B classeur ci-joint
peut-être comme ceci :
Private Sub Worksheet_Change(ByVal Target As Range)
'aiglon74
Application.EnableEvents = False 'force la majuscule
If Not Intersect(Target, Range("B8,D8,F8,H8,J8,L8,N8,P8")) Is Nothing Then
If Range("B8,D8,F8,H8,J8,L8,N8,P8") <> "" Then Target = UCase(Target)
End If
Application.EnableEvents = True
Dim cel As Range 'non trouvé en feuille "liste"
If Target.Address = "$B$8" Then
If Target = "" Then
ElseIf MsgBox("Etes-vous certain(e) de vouloir continuer ?", vbYesNo, "Demande de confirmation") = vbYes Then
With Sheets("Liste")
Set cel = .Columns("E").Find(what:=Target, LookIn:=xlValues, lookat:=xlWhole) 'ici <===
If Not cel Is Nothing Then
cel.Offset(0, 1).ClearContents
Else
MsgBox Target & " Non trouvé"
Range("B8").ClearContents
End If
End With
End If
End If
End Sub
Private Sub Worksheet_Activate()
On Error Resume Next
Range("B8").Select
End Sub
crdlt,
André