Private Sub ListBox1_Click()
Dim i%, j%, pos%, taille%
Dim DerligArrivee%
Dim Liste_Box()
Dim fDepart As Worksheet, fArrivee As Worksheet
Set fDepart = Sheets("Départ")
Set fArrivee = Sheets("Arrivée")
pos = 10000
DerligArrivee = fArrivee.Cells(Rows.Count, 1).End(xlUp).Row
DerligArrivee = DerligArrivee + 1
ReDim a(1 To 1, 1 To 6)
ReDim Liste_Box(ListBox1.ListCount - 1, 0 To 5)
For i = 0 To ListBox1.ListCount - 1
For j = 0 To 5
Liste_Box(i, j) = ListBox1.List(i, j)
Next j
If ListBox1.Selected(i) = True Then
For j = 0 To 5
a(1, j + 1) = ListBox1.List(i, j)
Next j
pos = i
End If
Next i
If fArrivee.Range("A2") = "" Then
fArrivee.Cells(DerligArrivee - 1, 1).Resize(1, 6) = a
Else
fArrivee.Cells(DerligArrivee, 1).Resize(1, 6) = a
End If
If pos <> 10000 Then
ListBox1.Clear
taille = UBound(Liste_Box) - 1
For i = pos To taille
For j = 0 To 5
Liste_Box(i, j) = Liste_Box(i + 1, j)
Next j
Next i
For i = 0 To taille
ListBox1.AddItem
For j = 0 To 5
ListBox1.List(i, j) = Liste_Box(i, j)
Next j
Next i
End If
End Sub