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


.