ADDING STOCK SOMEHOW???? OMG WTF PLZ HLP

[Sami]

I got a stock workbook with a list of product with the quantity of stock. when stock comes in i need to no a way of adding stock to each stock quantity for each item. drop down boxes - no way. i can get d input boxes to work but u need to no where to stop them. n it doesnt add the stock that has come in to the current stock automatically
PLZ HELP

 

[Sami]

...

 

[gplhl]

The code I put up adds the contents of the text box to the cell value.

 

[Sami]

hey that code works but... it adds the quantity into column C which is the price and not column D whic his the Quantity. Also this justs adds the stock u enter it doesnt add the stock to the stock already in that cell. plz can u help bcos this is urgent!!

 

[Sami]

hey sorry i just needed to change the 1 to a 2. It works brialliant. THANK UUUUUUUU!!

do you know how i could validate this so that only whole numbers between 0 and 200 will be accepted when enter is pressed???