Private Sub UserForm_Initialize()
n = [Tb].Columns.Count
ListBox1.ColumnCount = [Tb].Columns.Count
ListBox1.ColumnWidths = "50;90;80;70;70;70;60"
For k = 1 To n
Me("Label" & k) = [Tb].Item(0, k)
Me("Label" & k).Top = Me("Label" & k).Top + 5
Next
With Sheets("Factures")
lig = .Range("a65536").End(xlUp).Row
For x = 2 To lig
ListBox1.AddItem .Range("a" & x)
For j = 2 To 7
ListBox1.List(ListBox1.ListCount - 1, j - 1) = .Cells(x, j)
If IsDate(ListBox1.List(ListBox1.ListCount - 1, j - 1)) Then _
ListBox1.List(ListBox1.ListCount - 1, j - 1) = Format(.Cells(x, j), "dd.mm.yyyy")
Next j
Next x
End With
End Sub