Private Sub ListBoxClasse_Click()
'>>>------------------------------------------------------------
With Me.ListBoxNom
.Clear
.ColumnCount = 9
.ColumnWidths = "80 pt;80 pt;80 pt;80 pt;80 pt;80 pt;80 pt;80 pt;80 pt"
End With
Dim ArrInput() As String, i As Integer
Dim x As Integer
Dim ArrOutput As Variant
'<<<------------------------------------------------------------
Me.ListBoxNom.Clear
Set dchoisis5 = CreateObject("Scripting.Dictionary")
'>>>------------------------------------------------------------
i = 0
On Error Resume Next
ReDim ArrInput(0)
On Error GoTo 0
'<<<------------------------------------------------------------
For Each c In Range(f.[A2], f.[A65000].End(xlUp))
temp = c.Offset(, 4).Value & "#" & c.Offset(, 6).Value _
& "#" & c.Offset(, 7).Value & "#" & c.Offset(, 8).Value _
& "#" & c.Offset(, 9).Value & "#" & c.Offset(, 10).Value _
& "#" & c.Offset(, 11).Value & "#" & c.Offset(, 12).Value _
& "#" & c.Offset(, 13).Value & "#" & c.Offset(, 14).Value
If dchoisis.exists(c.Value) And dchoisis2.exists(c.Offset(, 1).Value) And _
dchoisis3.exists(c.Offset(, 2).Value) And _
dchoisis4.exists(c.Offset(, 3).Value) And _
c.Offset(, 9).Value = ListBoxClasse Then
dchoisis5(temp) = c.Row
'>>>------------------------------------------------------------
ArrInput(i) = temp
i = i + 1
ReDim Preserve ArrInput(i)
'<<<------------------------------------------------------------
End If
Next c
'>>>------------------------------------------------------------
If dchoisis5.Count > 0 Then
For x = LBound(ArrInput) To UBound(ArrInput)
ArrOutput = Split((ArrInput(x)), "#")
With Me.ListBoxNom
On Error Resume Next
.AddItem
.List(.ListCount - 1, 0) = ArrOutput(0)
.List(.ListCount - 1, 1) = ArrOutput(1)
.List(.ListCount - 1, 2) = VBA.FormatDateTime(ArrOutput(2))
.List(.ListCount - 1, 3) = ArrOutput(3)
.List(.ListCount - 1, 4) = ArrOutput(4)
.List(.ListCount - 1, 4) = ArrOutput(5)
.List(.ListCount - 1, 4) = ArrOutput(6)
.List(.ListCount - 1, 4) = ArrOutput(7)
.List(.ListCount - 1, 4) = ArrOutput(8)
End With
Next x
End If
'<<<------------------------------------------------------------
End Sub