Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ColumnHeads Property for ComboBox
Does anyone know how to make the 'ColumnHeads' appear in a ComboBox?
I have set the property with: frmFormName.ComboBoxName.ColumnHeads = True The heading row appears but no text is in it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ColumnHeads Property for ComboBox
"VBA Dabbler" wrote in message
... Does anyone know how to make the 'ColumnHeads' appear in a ComboBox? I have set the property with: frmFormName.ComboBoxName.ColumnHeads = True The heading row appears but no text is in it. Column heads only work when the RowSource property of your ComboBox is set to a range on a worksheet. In that case the row values in the row directly above the row source range will be used as the column head(s). -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ColumnHeads Property for ComboBox
Thanks for the feedback. I never saw in Microsoft's documentation where that
functionality was restricted to use of the RowSource property. It would be nice if they would publish it. Regards, VBA Dabbler "Rob Bovey" wrote: "VBA Dabbler" wrote in message ... Does anyone know how to make the 'ColumnHeads' appear in a ComboBox? I have set the property with: frmFormName.ComboBoxName.ColumnHeads = True The heading row appears but no text is in it. Column heads only work when the RowSource property of your ComboBox is set to a range on a worksheet. In that case the row values in the row directly above the row source range will be used as the column head(s). -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLE Combobox MatchRequired property not working | Excel Programming | |||
Combobox change property | Excel Programming | |||
Cont' Value and Text Property of Combobox | Excel Programming | |||
ListBox.ColumnHeads Property | Excel Programming | |||
Listbox ColumnHeads | Excel Programming |