For a school project I am working on I have a database of stock levels. The database is basically a table on a Stocks Worksheet. Each row is a different product and the various columns afterwards contain the stock levels for each size.

On an Order Worksheet, I have a userform which the user types in their product and how many they require. When they hit OK, the sheet displays their stock, the current stock and what the stock will be (i.e it takes the order value away from the current value.) If everything is OK, the user can click on a button which verifies the order. I need a macro or simple VBA script that will take the new stock levels, search through the database and find the row which has the same product code and update the stock levels. Any ideas.

Also, is it possible to validate the information entered into TextBoxes on userforms?

Thanks in advance.