Userform code for .find function to adjust cell data

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

You can't do that unless you have the user pick the description first... like Winon said

But I have a different solution! Give me 10min

I have a solution! I hope
Give me 5min to work it out hehe

Ha! I think I did it
Try this out.

Winon, thanks
I Know what you mean. I've used that with the Validation options for cells. But I don't know how to do it for userform.
Would prorobly need a Combox_Change event I can try... but will need more time. I need to do something for work right now.
But thats a nice idia though Then actualy there wouldn't have to be if the Manufacturer, Part No and Description exist, because you could only pick what already exists

@Winon
So this actualy works as you said.
But the problem now is if a user selects something in the first combox and then in the second combox and decides to change the first combox the values in the dropdown menu in the second combox will contain the previus selection list and the new selection list.
Any idias about that?

Guys,
Thanks for your help and advice of this, I am unable to have a look at what you have done until tonight.
Just to reply to Winon's first comment, I plan to develope different part no's for all different parts to prevent the issue you have suggested.

stojko89: Thanks for your work, I will look at tonight.

This forum is Great!!!

Cheers

Dan

I think I got it! Wait just 5min hehe

Hello,
Had a good play last night, Thanks for your work Stojko89. I have changed it slightly and removed the need to search for the description, so only a partno and manufacture are needed. When I add stock to the stores I shall give them individual part. no.s. The only thing I am looking to do now is to keep the data sorted from A-z, But i think I can do that.

Again, Thanks for your help in the matter.
You both deserve a pat on the back!!

Thanks

Dan

yeh Winon! You too but still don't know how to work that out hehe, maby someday