VBA ColumnHeads Property for ComboBox

[Guest]

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.

 

[Rob Bovey]

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

 

[Guest]

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