Impossible to fill the header of a ListBox that is in a Sheet.

Hello,
I have created a ListBox (ActiveX) on a worksheet (and not in a UserForm).
I try to fill this list with VBA by calling this function :

Please Login or Register  to view this content.

It fills the list entirely but it misses the header line. Actually, the titles appear in the second line, and the header line remains empty !
( despite my .ColumnHeads = True)

What is strange, it is that when I do this in a UserForm (with a 'regular' ListBox), the result is correct.
But definitely, when I do it in a ControlX listBox located on a sheet (and not in a UserForm), it fails...

Any idea please ?
Thanks anyway...Pierre

Thank you for your answer. You are right, my lines were too specific.

Here is a an Excel Workbook with a sheet 'Feuil1' containing a ControlX ListBox named 'ListBox1'.
(provided here).

A Click on button 'Bouton3' populates the ListBox, and the same problem occurs (header line is empty).

More than this, I realize that I am unable to get the selected value back (ListBox1_Click() does not work)

Thanks again, Pierre

Please Login or Register  to view this content.

The last point (getting the value selected back) is solved. I do this in the module :

Please Login or Register  to view this content.

And this in the "Feuil1" code part:

Please Login or Register  to view this content.

thanks... I go for making a range and link it to the LB...

Sorry but I keep on failing, even with a Range (or a Table).

I give you my attempt (TestLBCotrolXRange.xlsm)

I build the range in a "Fake" sheet (as well as a table based on this range).

Then I try to link this range (or the table) to the listbox... but it does not work

Thanks again...

Sorry but I don't see which line :

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

Thank you, that helps a lot, but still, I cannot have my header values in the header line of the listbox, these titles appear below, in the list itself.LB.png

That's perfect ! Many thanks to you
Perfect.png