Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can a combo box display headings or do you have to have
labels on a form above the combo box for the headings? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you set the items of the combobox in a range, with the heading in the
first row of the range, you can use the RowSource property to link to that range, and then set the ColumnHeads property to True. -- Regards Juan Pablo González "JT" wrote in message ... Can a combo box display headings or do you have to have labels on a form above the combo box for the headings? Thanks |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Set the columnheads property to true,
but this will only work if the box if filled using the rowsource or listfillrange properties (the control is databound). Then it gets its heading from the row above the range assigned. -- Regards, Tom Ogilvy "JT" wrote in message ... Can a combo box display headings or do you have to have labels on a form above the combo box for the headings? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the headings from A1 A2 etc to show my headings? | 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) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |