Columnheads does not display in listbox!

[newskin]

On page "Tim_TKSua" pls help me why column name doesn't display although i had choice columnheads is true in properties for listbox1. I had attachments file, pls help me. Thanks all.

[excelliot]

To use the headings, unfortunately, you have to tie the ListBox to a range. If you add the data through code, as you are, there's no way to accomplish it.

[Kenneth Hobs]

I would use RowSource in the Initialize event rather than Activate.

ListBox1.RowSource = shBangMa.Range("A1:T" & LastRow).Address ''priArrList

[newskin]

ok, thanks all. pls close thread!

[SamT]

I will mark the thread "Solved" this time, but you can do it yourself with the "Thread Tools" Menu.