For each combobox, set the RowSource property to that range, including the
sheet name. BTW, I assumed that when you said workbook, you meant worksheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nannon8" wrote in message
ups.com...
I have an excel template which has some userforms in it. On one of the
userforms are 9 combo boxes, all of which need to display the same data
from another workbook. Problem is I don't have a clue how to achieve
this, can anyone help?