ListBox.ColumnHeads Property
 

I am using a ListBox to display some multicolumn data and am trying to use the ColumnHeads property to display, well ..., column heads. I set the property to True, but can't find any reference in the help to how to enter the names of the column heads.

The help files did mention, "When the system uses the first row of data items as column headings, they can't be selected", but shed no light on how to accomplish this.

Any help would be appreciated. Thanks!

--
Kevin

ListBox.ColumnHeads Property
 

You have to bind your control to the data using the rowsource (userform) or
listfillrange (worksheet) property. Then the column heading is the row
above the range you bind to.

so if you set the rowsource to

Sheet1!A2:C20

then sheet1!A1:C1 will display as the column heads if you set columnheads
property to true.

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
I am using a ListBox to display some multicolumn data and am trying to use
the ColumnHeads property to display, well ..., column heads. I set the
property to True, but can't find any reference in the help to how to enter
the names of the column heads.

The help files did mention, "When the system uses the first row of data
items as column headings, they can't be selected", but shed no light on how
to accomplish this.

Any help would be appreciated. Thanks!

--
Kevin

ListBox.ColumnHeads Property
 

Thanks for responding.

It is currently not bound to anything. I am doing some processing in the background and which generates a list of items that I have been adding using the AddItems method of ListBox.

Is there any way to achieve ColumnHeads without using the ListBox as a bound control? If not, that seems rather shortsighted and limiting.
--
Kevin


"Tom Ogilvy" wrote:

You have to bind your control to the data using the rowsource (userform) or
listfillrange (worksheet) property. Then the column heading is the row
above the range you bind to.

so if you set the rowsource to

Sheet1!A2:C20

then sheet1!A1:C1 will display as the column heads if you set columnheads
property to true.

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
I am using a ListBox to display some multicolumn data and am trying to use
the ColumnHeads property to display, well ..., column heads. I set the
property to True, but can't find any reference in the help to how to enter
the names of the column heads.

The help files did mention, "When the system uses the first row of data
items as column headings, they can't be selected", but shed no light on how
to accomplish this.

Any help would be appreciated. Thanks!

--
Kevin

ListBox.ColumnHeads Property
 

"Kevin" ...

I am doing
some processing in the background and which generates
a list of items that I have been adding using the
AddItems method of ListBox.

Is there any way to achieve ColumnHeads without using
the ListBox as a bound control? If not, that seems
rather shortsighted and limiting.

Here's some good advice from history:

http://groups.google.com/groups?selm... west.msn.net

Whatever happened to that guy? <g

Jamie.

--

ListBox.ColumnHeads Property
 

I forgot to mention, you may like to try the code recently posted
he

http://groups.google.com/groups?selm...g .google.com

Jamie.

--