VBA Question: Populating a combobox with column headers.

dbmathis

Well-known Member
Joined
Sep 22, 2002
Messages
1,064
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.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,061
Office Version
  1. 365
Platform
  1. Windows
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.:)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,674
Messages
5,573,598
Members
412,537
Latest member
Mohamed_5966
Top