HELP! Userform VLOOKUP , RESET and Add/Remove

Hi All,

I joined a few nights ago and have been researching on the forums trying to solve my problem myself, only to confuse myself even further. I would love one of you pro's to give me 10 mins and a bit of guidance !!!

I am building a very simple 1 sheet workbook called 'data' that will act as a stock in/out inventory control. Very basic, Column A is Part Number, Column B is Quantity and Column C is Location.

I have created 2 userforms that toggle between each other with the main sheet non-visible. All good so far...

The main userform 'frmInventory' has a a combobox that I think I have got right. It uses part numbers form Column A as a reference when typing input. I then need the quantity and location to be population when the search key is pressed (or user clicks out of combobox it seems)?

Once the partnumber has a match, the quantity can be shown and/or adjusted either by ADDING or SUBTRACTING from the existing stock row in sheet1 using the 'add to stock' or 'remove from stock' buttons some sort of message confirming the action.

If the partnumber is not found, the user must use frm.newitem to add a new partnumber to the sheet1("data") Column A..

Then there's the reset buttons that I had a .clearcontents on but that didnt work either...

I have included the file and removed most of my bad code to simplify things..

PLEASE HELP!! THANK YOU ALL!

Regards,
Vaughan