Hi All,
I have a project on going which consists of a database of parts held in a stores, I am stuck on one final issue, which I have searched for, but not really been successful in working out.
If possible can someone point me in the right direction please.

I have made a User form to allow the operator to add stock back into the store if they decide they no longer require the part they have previously booked out. The way I thought it would work is to open the form via a command button
Enter the part no and quantity the wish to put back.Press OK.
The code will then search a certain row to find the part no. Use the .Offset function to active the 'Quantity' cell and then add +1 to the value
I think I have managed to work out most of it apart from the searching part.

Can anyone help, or explain how the .Find function works?

I have attached the fiile for info.

Thanks in Advance
Store file.xlsm


Dan