Suppose you have 2 workbooks with names book1.xls and book2.xls. In cells A1:A10 of the workbook book1.xls has data. I want to put a combo-box in the workbook book2.xls with matching data in cells A1:A10 of the workbook book1.xls.

Thanks in advance.