Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listbox shrinks to a line when changing between sheets if I use the visible property | Excel Programming | |||
Listbox ColumnHeads | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
ListBox ColumnHeads | Excel Programming | |||
Listbox text property not working correctly | Excel Programming |