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