Hi, I have basic knowledge of VBA and wanted to create a userform that looks up a product from one cell and edits a cell in the same row based on the userform input. This is what I have at the moment:
Example.jpg
I would like to be able to select a stock then add or remove volume so that it increases or decreases the value in the current stock column based on the value entered in the user form. Any help would be greatly appreciated.
Test.xlsm
Bookmarks