Listbox column headers when data is collected in an array

[evertjvr]

I want to apply the column headers to a listbox see the previous http://www.excelforum.com/excel-prog...es-please.html

The

Please Login or Register  to view this content.

is set and the header boxes appear but the boxes are empty.

Please help.

[evertjvr]

Here is the combined file with the missing headers.

List Box History (1).xlsm

Thanks

[JosephP]

you can only use column headers if the source data is in a range and you use the listfillrange property (the row above the listfillrange will be used).

[evertjvr]

Wow, something excel can not do.
Thanks.

So I can not have the easy column headers but I WILL have them my way then

I stretched the data array to include the header and jump to the data population part of the code.

here is the modified part

Please Login or Register  to view this content.

Thanks for your help.