Re: Display/Show Column Headings In ListBox
A ListBox will only display headings when the RowSource property is set to a range on a worksheet. The headings will be taken from the cells directly above the first row of RowSource.
It is not possible to add headings to the ListBox using code.
The only alternatives are to add labels above the listbox (Total PITA) or write the recordset to a worksheet (starting in row 2), use that as the Rowsource and then add the column names, using code, to the row above the list.