1. Go to Sheet2
2. Highlight the list
3. Click Insert - Name - Define
4. Type "Mylist" in the "Names in Workbook" box
5. Click OK
6. Go to Sheet1
7. Click the Design Mode icon on the Control Toolbox toolbar
8. Right click on the ComboBox and select Properties
9. In the Properties list scroll down to the field ListFillRange
10. Click in the empty box to the left and enter "Mylist"
11. Close the Properties box
12. Exit Design Mode (click the Design Mode icon again)
13. use the Combo Box

oh, and clear out your existing code for the ComboBox in the VBA editor. It's only throwing errors around, anyway.