Listbox does not load first column :(

[augoustinos]

I am trying to load a Listbox with the below code. However, the list box loads information from the second column onwards only. Any idea why?

Private Sub UserForm_Initialize()

'taille formulaire UserForm1.Height = 505 UserForm1.Width = 960 'initialisation formulaire ListBox1.ColumnCount = 8 ListBox1.List = Sheets("ListePaiements").Range("A1:G10000").Value

End Sub

Thank you all for your help!!!!

Agou

 

[Fluff]

Hi & welcome to MrExcel.
Do you mean that col A does not appear in the listbox?

 

[augoustinos]

Hi & welcome to MrExcel.
Do you mean that col A does not appear in the listbox?

Thats exqctly it

 

[Fluff]

In that case check that you have not set the column width of the listbox to 0 for the 1st column.