I have an Outlook UserForm that needs to populate a ComboBox from an Excel spreadsheet.

However, i am new at all this and cannot work out how to open a specified workbook / spreadsheet / cell and obtain the values to populate the Combobox.

Thanks all

(Windows XP / Office 2003)