"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