Private Sub DTPicker1_Change()
Dim Cell As Range
Dim X As Byte
Dim k As Integer
k = Worksheets("Mouvts").Range("A65536").End(xlUp).Row
With Me.ListView1
ListView1.ListItems.Clear ' vide le ListView avant de le remplir
'--> Si date est identique à DTPicker alors affichage sinon MsgBox "Date inexistante"
'---> If .ListItems.Count = Int(Me.DTPicker1) Then
'If Cells(k, 0) = Int(Me.DTPicker1) Then
'.ListItems.Clear
For Each Cell In Worksheets("Mouvts").Range("A3:A" & k)
If Cell.Value = Int(Me.DTPicker1) Then ' Ajout ici pour la comparaison
X = X + 1
.ListItems.Add , , Cell
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 1)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 2)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 3)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 4)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 5)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 6)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 7)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 8)
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 9)
End If ' terminer le IF
Next
' End If
End With
End Sub