Heading in a Listbox

[Guest]

When working in an UserForm and setting a listbox properties to show 5 columns and setting Hedings to true, how can I fill the heading ?

 

[Tom Ogilvy]

It only works if you use the rowsource property to fill the listbox. If you
do, it takes the row above the first row of the rowsource range as the
header. If you use row1, then it uses the column headers in the sheet.

--
Regards,
Tom Ogilvy

When working in an UserForm and setting a listbox properties to show 5

columns and setting Hedings to true, how can I fill the heading ?

 

[Guest]

Hi Tom

Thanks for your answer.

Just to check...

If I need to deal programatically with the listbox head, I have to fill the cells with the information and then fill the listbox.

Is that correct?


Thanks in advance.


Joe

 

[Tom Ogilvy]

If you want something to appear in the header, then it needs to be in the
cells in the row above the range specified in the rowsource property. If
those cells are empty, then I suppose you would need to fill them.

--
Regards,
Tom Ogilvy

Hi Tom

Thanks for your answer.

Just to check...

If I need to deal programatically with the listbox head, I have to fill

the cells with the information and then fill the listbox.