augoustinos
New Member
- Joined
- May 28, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
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()
End Sub
Thank you all for your help!!!!
Agou
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