populating a combobox on a worksheet

  • Thread starter Thread starter Tim Marsh
  • Start date Start date
T

Tim Marsh

Hi All,

I would like to populate a combobox on worksheet "Products" with headings
from a table in another worksheet "ProdList" range b1:o1 (a row of cells
rather than a column). i can do this ok when the items are in a column, but
when i try it with table headings (ie, a row) it only takes the value of the
first cell.

does anyone know how i would do this? either by using the control's
properties or by a sub ...()?

Many thanks,

Tim
 
Headings are taken from the row above the rowsource/listfillrange range. So
you can't use a column.
 
You can use Paste Special / Transpose in order to put
those heading in a column. If the heading list is dynamic
(changes a lot), you can make a macro which do the trick.
-----Original Message-----
Hi All,

I would like to populate a combobox on
worksheet "Products" with headings
 
Back
Top