populating a combobox on a worksheet
 

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

populating a combobox on a worksheet
 

Headings are taken from the row above the rowsource/listfillrange range. So
you can't use a column.

--
Regards,
Tom Ogilvy

"Tim Marsh" wrote in message
...
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

populating a combobox on a worksheet
 

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
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


.