Bonjour à tous,
Un essai > trouve les numéros (chiffres) même s'il y en a plusieurs dans une feuille ...
Private Sub UserForm_Initialize()
Dim Trou As Range
Dim last As Long
Dim Jecherche As Integer, J As Integer
Dim FirstAddress As String
Dim NomFeuille As String
Resul.ColumnHeads = True
Resul.ColumnCount = 5
Jecherche = 4529
For J = 1 To Worksheets.Count
NomFeuille = Worksheets(J).Name
With Worksheets(J)
last = .Range("A" & Rows.Count).End(xlUp).Row
Set Trou = .Range("A1:A" & last).Find(Jecherche, LookIn:=xlValues)
If Not Trou Is Nothing Then
FirstAddress = Trou.Address
Resul.AddItem .Cells(Trou.Row, 1)
Resul.List(Resul.ListCount - 1, 1) = .Cells(Trou.Row, 4)
Resul.List(Resul.ListCount - 1, 2) = .Cells(Trou.Row, 6)
Resul.List(Resul.ListCount - 1, 3) = .Cells(Trou.Row, 7)
Resul.List(Resul.ListCount - 1, 4) = NomFeuille
Do
'mark the cell in the column to the right if "Ron" is found
Set Trou = .Range("A1:A" & last).FindNext(Trou)
If Trou.Address <> FirstAddress Then
Resul.AddItem .Cells(Trou.Row, 1)
Resul.List(Resul.ListCount - 1, 1) = .Cells(Trou.Row, 4)
Resul.List(Resul.ListCount - 1, 2) = .Cells(Trou.Row, 6)
Resul.List(Resul.ListCount - 1, 3) = .Cells(Trou.Row, 7)
Resul.List(Resul.ListCount - 1, 4) = NomFeuille
End If
Loop While Not Trou Is Nothing And Trou.Address <> FirstAddress
End If
End With
Next J
End Sub
ric