VBA Question: Populating a combobox with column headers.

[dbmathis]

I have 36 columns of data on my sheet. The header for the columns is in Range B10:AK10.

How would I populate my combobox with the data in the above header Range?

I have found several examples of adding rows, but have not found anything like what I am looking for.

Thanks.

 

[Norie]

The only way, as far as I know, to have headers in a combobox is using the RowSource property to populate it and setting ColumnHeads to True.

By the way 36 columns seems a bit much for a single combobox.

 

[dbmathis]

Thanks Norie. Will try.