combo box displays values from a list drawn from spreadsheet

Hi guys,

Just experimenting using a combo box to display a list of values from a tab but keep running into a problem. I've attached the file. Please go to the code window and test run the userform1.

Please Login or Register  to view this content.

When I run it, it says Method range of object failed error...

Can anybody help me with this? I think the logic makes sense, which is set variables, find the last row in col A, then make a loop that starts from top to lastrow??

Thanks