| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Data to Appear as Column Headings in Another Sheet | Excel Discussion (Misc queries) | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| How do I keep column headings from showing on a list? | Excel Worksheet Functions | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
