Add/Subtract cell value using Option Button

[liquid_gen14255]

Hi,

Im not an expert on this vba excel but i have this user form for my parts inventory.
I want to keep the file to be updated once a part is withdrawn or added.

when someone wants to withdraw/deposit a part it will use the user form to display the part details and enter the amount need to withdraw/deposit.
Capture.JPG

user will select on the option button either adding or taking out.
Then will click submit to add or subtract the amount entered
the new value will be reflected on the excel file

Thanks.....



This is my code:


----------------------------------------------------------------------------------------

Please Login or Register  to view this content.

----------------------------------------------------------------------------------------

**NOTE: IM NOT SURE IF THIS CODE IS CORRECT***

Please Login or Register  to view this content.

[vlady]

Welcome to the forum.

When posting codes please use code tags.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Since this is your first post I will do it for you.

Regards,
Vladimir