Sub Recherche()
nom = Application.InputBox("Saisir texte/chiffre(s) à trouver :", "Rechercher")
If VarType(nom) = vbBoolean Then 'Touche Annuler
nom = CStr(nom)
Exit Sub
End If
If nom = "" Then
Application.EnableEvents = False
MsgBox ("Faudrait p'être saisir le(s) texte/chiffre(s) à trouver !")
[a3].Select
Application.EnableEvents = True
Exit Sub
End If
Application.EnableEvents = False
q = ActiveSheet.Index
For q = q To ActiveSheet.Index + Sheets.Count - 1
K = (q - 1) Mod (Sheets.Count) + 1
With Sheets(K).UsedRange
Application.ScreenUpdating = False
Set C = .Find(nom, LookAt:=xlPart) 'LookAt:=xlpart dans cellule - LookAt:=xlWhole) 'cellule entière
'[a1].Activate
If Not C Is Nothing Then
firstAddress = C.Address
Do
On Error Resume Next
Sheets(K).Select
C.Activate
Application.ScreenUpdating = True
ActiveWindow.ScrollRow = Selection.Row
Rep = MsgBox("A trouver : " & nom & Chr(10) & "- OK dans " & ActiveSheet.Name & Chr(10) & "- Colonne " & Split(C.Address, "$")(1) & Chr(10) & "- ligne " & C.Row & Chr(10) & Chr(10) & "Continuer la recherche ?", 4 + 32, "Résultat")
If Rep = vbNo Then
Application.EnableEvents = True
Exit Sub
End If
Application.ScreenUpdating = True
Set C = .FindNext(C)
Loop While Not C Is Nothing And C.Address <> firstAddress
End If
End With
Next q
MsgBox "Ben NON : y'a pas ou y'a plus !"
Application.EnableEvents = False
[a3].Select
Application.EnableEvents = True
End Sub