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.

"VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message
news:36A85296-6CEC-4330-A9A6-3BA5042A23B9@microsoft.com...
> 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

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" <VBADabbler@discussions.microsoft.com> wrote in message
> news:36A85296-6CEC-4330-A9A6-3BA5042A23B9@microsoft.com...
> > 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
>
>
>