ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   headings in a combo box (https://www.excelbanter.com/excel-programming/322748-headings-combo-box.html)

JT[_2_]

headings in a combo box
 
Can a combo box display headings or do you have to have
labels on a form above the combo box for the headings?

Thanks

Juan Pablo González

headings in a combo box
 
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




Tom Ogilvy

headings in a combo box
 
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





All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com