gene

I have been trying to develop a system using excel forms with vba.
The problem I am having is with the vlookup in vba, It works on the spreedsheet but i guess I don't understand how to get it working in vba.

I have set up a very basic spreedsheet and a vba form. When ever I try to run it I get a 1004 error.

I have attached a copy of the what i am testing.