PDA

View Full Version : [SOLVED:] Set Columns Names in ListBoxes



D_Marcel
09-26-2017, 07:17 AM
Guys,
Can you please help me with this issue?
I'm trying to create a multicolumn ListBox and using the RowSource property to insert the values, but....

20473

Why the first row doesn't appear as header? This is so frustrating.

Private Sub UserForm_Initialize()
Me.ListBox1.ColumnHeads = True
Me.ListBox1.MultiSelect = fmMultiSelectMulti
Me.ListBox1.ListStyle = fmListStyleOption
Me.ListBox1.ColumnCount = 3
Me.ListBox1.RowSource = Plan11.Range(Cells(1, 1), Cells(11, 3)).Address
End Sub

Thanks for any help!

Douglas Marcel

Paul_Hossler
09-26-2017, 07:49 AM
Try starting at the second row




Me.ListBox1.RowSource = Plan11.Range(Cells(2, 1), Cells(11, 3)).Address

D_Marcel
09-26-2017, 09:39 AM
Solved!
Thanks @Paul

Regards,