gene

[MARYGENEBU]

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.

[shg]

There is no attachment, MARYGENEBU.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[royUK]

I think you would be better using the Find Method, look at the example in Excel's VBA Help files