Search and display results in userform Issue. Results are incorrect

I have a userform that searches for a product based on a unique number for example( 664907 Printers tray £40.00) this data is located in a sheet called "Stock" Column A has the unique number Column B Has the Item name And column C has the Price.

I have created the userform to search and return the results of column B & C in two Textboxes on the userform.

I also have a clear and add button that works perfectly , however i am struggling, sometimes the results that the userform displays are incorrect. It will jump to a different unique number after i have clicked seraph? Sometimes it will wok and other times it will not, Can anyone help/

Here is the code i am using at present. If anyone can help me this would be great.

Please Login or Register  to view this content.

can you upload a sample workbook?

Thanks, The search button that brings up the userfom is on sheet 1, the results when you click add will be copied top sheet 2 and the stock list is where the results are found,
if you try a couple of numbers you will notice that at first it works but then jumps to a different number and product no matter what unique id Number you put in.

Thanks

Thanks, Is it that simple. lol, Wow it all works now. Is there any way to define the colums the serach takes place in and ignores the sold items ? i could always move this info on to another page i guess and still use Vlookup to check stock etc. Thankyou