List Box Column Headings

[Richard Mogy]

I have looked in many places and realize this is probably simple, but how do
I put column headings in my columns in my listbox?

I have set column headings to true, but then what?

Thanks in advance

 

[Norman Jones]

Hi Richard,

If the listbox is on a userform, setting the ColumnHeads property to True
will pick up the headings from the row above the range set for the RowSource
property.

If the listbox is on a worksheet, setting the ColumnHeads property to True
will pick up the headings from the row above the range set for the
ListFillRange.

 

[Richard Mogy]

I'm getting the data from an external source on a userform.

 

[Tom Ogilvy]

You can't use the columnheads property then. You would have to simulate
them with a row of textboxes or a one row hide listbox above your other
listbox.