Private Sub Rechercher()
' Rechercher les données en fonction des critères
Dim rCel As Range
Dim lgLig As Long
Dim lgLigDeb As Long
Dim pp1 As String
Dim pp2 As String
Dim pp3 As String
Dim pp4 As String
pp1 = "*"
pp2 = "*"
pp3 = "*"
pp4 = "*"
If nom.Value <> "" Then pp1 = nom.Value
If prenom.Value <> "" Then pp2 = prenom.Value
If datenais.Value <> "" Then pp3 = datenais.Value
If nom_mere.Value <> "" Then pp4 = nom_mere.Value
Resultat.ListBoxLocataire.Clear
' Cas des personnes physiques uniquement
'With Sheets("conso_pp")
' Boucle de la 6eme à la dernière ligne de la feuille
For lgLigDeb = 6 To ThisWorkbook.Sheets("conso_pp").Range("A" & Cells.Rows.Count).End(xlUp).Row
' LCase permet de transformer une chaine de caracteres en minuscules
If LCase(ThisWorkbook.Sheets("conso_pp").Range("C" & lgLigDeb).Value) Like LCase("*" & pp1 & "*") _
And LCase(ThisWorkbook.Sheets("conso_pp").Range("D" & lgLigDeb).Value) Like LCase("*" & pp2 & "*") _
And LCase(ThisWorkbook.Sheets("conso_pp").Range("E" & lgLigDeb).Value) Like LCase("*" & pp3 & "*") _
And LCase(ThisWorkbook.Sheets("conso_pp").Range("G" & lgLigDeb).Value) Like LCase("*" & pp4 & "*") _
Then
With Resultat.ListBoxLocataire
.AddItem ThisWorkbook.Sheets("conso_pp").Range("A" & lgLigDeb).Value
.List(.ListCount - 1, 1) = ThisWorkbook.Sheets("conso_pp").Range("B" & lgLigDeb).Value
.List(.ListCount - 1, 2) = ThisWorkbook.Sheets("conso_pp").Range("C" & lgLigDeb).Value
.List(.ListCount - 1, 3) = ThisWorkbook.Sheets("conso_pp").Range("D" & lgLigDeb).Value
.List(.ListCount - 1, 4) = ThisWorkbook.Sheets("conso_pp").Range("E" & lgLigDeb).Value
.List(.ListCount - 1, 5) = ThisWorkbook.Sheets("conso_pp").Range("G" & lgLigDeb).Value
.List(.ListCount - 1, 6) = ThisWorkbook.Sheets("conso_pp").Range("H" & lgLigDeb).Value
.List(.ListCount - 1, 7) = ThisWorkbook.Sheets("conso_pp").Range("I" & lgLigDeb).Value
.List(.ListCount - 1, 8) = ThisWorkbook.Sheets("conso_pp").Range("M" & lgLigDeb).Value
.List(.ListCount - 1, 9) = ThisWorkbook.Sheets("conso_pp").Range("N" & lgLigDeb).Value
'.List(.ListCount - 1, 9) = Range("N" & lgLigDeb).Value
lgLig = lgLig + 1
End With
End If
Next lgLigDeb ' Fin de la boucle For
'End With
End Sub