Negetive numbers/Subtracting values in userforms.

[BPSJACK]

Hi, I have a userform where the user will enter (in textboxes) quantities of products which have been dispatched. At the moment when the userform is submitted it will add the values to its assigned cell in sheet1. What I would like to do is to make the userform subtract the value, or force the numbers entered to become negative, so that they can be reduced from a running balance of product quantities.

Does anyone have any ideas how I could code the userform to achieve this? Thanks in advance for any help you can offer me.

[tigeravatar]

BPSJACK,

Here's one way...

Please Login or Register  to view this content.

[BPSJACK]

My userform needs to enter the data to the next empty row. When I used the ABS value to subtract it as suggested , I just return a value of zero each time. I tried to amateurly modify it but now get a runtime type mismatch. Can anyone more knowledgeable than me see where I’m going wrong?

Please Login or Register  to view this content.

[tigeravatar]

BPSJACK,

Do those textboxes contain numeric data?

[BPSJACK]

Your question pushed me in the right direction. I noticed that it wouldnt throw up an error when every text box had numeric data entered to it. So I just set it to assign a zero (used code below) to textboxes whenever they are left blank. Seems to have solved the problem.

Please Login or Register  to view this content.