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