List Box Column Headings
 

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

List Box Column Headings
 

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.

---
Regards,
Norman



"Richard Mogy" wrote in message
. com...
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

List Box Column Headings
 

I'm getting the data from an external source on a userform.
"Norman Jones" wrote in message
...
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.

---
Regards,
Norman



"Richard Mogy" wrote in message
. com...
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

List Box Column Headings
 

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.

--
Regards,
Tom Ogilvy

"Richard Mogy" wrote in message
m...
I'm getting the data from an external source on a userform.
"Norman Jones" wrote in message
...
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.

---
Regards,
Norman



"Richard Mogy" wrote in message
. com...
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