Private Sub UserForm_Initialize()
Sheets("Données").Activate
Ncols = [Tableau1].Columns.Count + 1 ' on rajoute une colonne pour le n*° de ligne
Bd_Reformat
Charge_Listbox1
With ListBox1
.ColumnCount = Ncols
.ColumnWidths = C_Width & "10;"
.Width = L_Width + 10 ' 10=largeur empirique du vertical scroll
.IntegralHeight = True
Frame1.ScrollWidth = .Width
End With
With ListBox0
.Width = L_Width + 5
.ColumnCount = Ncols - 1
.ColumnWidths = C_Width
.List = [Tableau1[#Headers]].Value
End With
End Sub