Problem Listbox Header from VBA Userform

[Doflamingo]

Dear all,

I currently have problem with the header added to my listbox. It has been activated (listbox property where columnheads of the listbox = true) but I don’t know why the code below

Listbox1.rowsource = (“E1”)

Where in the cell E1 from an excel sheet its’ written ‘’blabla’’ but the header of the listbox makes appear in the header ‘’E1’’ and below the header ‘’blabla’’

How to make appear the value of the cell E1 in the lisbox header ?

Or if anyone knows how to populate header of listbox without using cells value of an excel sheet, I take it

 

[Domenic]

Since ColumnHeads is set to True, you don't include the header row in your reference. For example, let's say that E1 contains the header, and E2:E5 contains the list items, you should assign the row source as follows...

 [COLOR=#333333]Listbox1.rowsource = "E2:E5"


[/COLOR]

Hope this helps!

 

[Doflamingo]

Hi Hello @Domenic, many thanks for your explanations. It works

I know now how columnheads work but unfortunately it does not work with my multiple lines of code that look like this

If OptionButton1.Value = True And OptionButton5.Value = True Then Me.ListBox2.AddItem ("Wck")

Actually i just wanted column head because before I used ''labels'' to indicate what was the utility of the listbox and then I though having headcolumn just would be more convenient for the user of the VBA userform

but it prevents my code working so, not grave, but many thanks for your reply, help and time on that matter