Hi guys,
I have never done maths in VBA before, so would appreciate your help.
It is a very simple equation:
txtStockEOS1 = txtStockSOS1.value + txtStockReceive1.value - txtStockLost1.value - txtStockBroken1.value - txtStockWorn1.value
I.e., 10 = 5+8-1-1-1
Thank you!
Last edited by onmyway; 02-05-2015 at 06:30 AM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
hi shg
Thanks for the response.
How or where would I put the code? I would like the TextBox to calculate every time one of these fields change?
Please Login or Register to view this content.
In the Change event for each of textboxes on the right side of the = sign.
thank you shg
You're welcome.
hi shg,
I get a run-time error 13: type mismatch when I enter a value in one of my fields whilst testing. this is my code:
I am probably making some simple mistake...Please Login or Register to view this content.
What the value in each textbox when the error occurs?
Hi shg,
Sorry for the belated response. Was over-committed this weekend.
The error occurs no matter what value I enter. Numeric or alpha-numeric.
Hi shg,
Sorry for the belated response. Was over-committed this weekend.
The error occurs no matter what value I enter. Numeric or alpha-numeric.
Hi all,
I still have not been able to solve this problem. I get a run-time error 13: type mismatch when I enter a value in one of my fields whilst testing. this is my code:
Please Login or Register to view this content.
FYI: When I calculate using a button, it works perfectly. it is the autocalculation via the _Change event that is causing the issue. it might have something to do with empty/blank fields?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks