VBA math formula

**zplugger** · 03-13-2009, 12:58 PM

Having a real hard time with this,able to do it in normal excel, this project I'm using vba. Here is a example of what I can not do, if you can give a a formula for this I will be real Happy.
Thank You

**mewingkitty** · 03-13-2009, 01:11 PM

What I’m trying to do is box1 and box2 =sum
box3 and box4 =sum
box5 and box6=sum

sum of what?

**mewingkitty** · 03-13-2009, 01:29 PM

Please Login or Register  to view this content.

That works, took out your "Val" at the end, not too sure what you were trying to do with that. Left the rest of your code as is, not sure the basis for the /12's and the +, *, etc. You didn't explain those so I left them alone.

**DonkeyOte** · 03-13-2009, 01:29 PM

Try:

Please Login or Register  to view this content.

VAL will handle empty textboxes - if blank the code will fail (null is non-numeric)... also if you had something odd like 12 Apples it would use 12.

**zplugger** · 03-13-2009, 01:52 PM

Thank you very much for your time on this, it works great. I'm just learning this stuff and there is a lot of very helpful people here like you. I hope to be able some day to help other people at learning this stuff.

**mewingkitty** · 03-13-2009, 01:57 PM

Yay! I got to learn something too

**are-ref** · 01-02-2014, 04:35 AM

hai... can i know where to put VAL for my code below???

txt7.Value = ((((txt9.Value - txt1.Value) * txt3.Value) - (txt3.Value - 1)) * (txt6.Value - (txt4.Value + txt5.Value)))
txt11.Value = ((txt8.Value * txt9.Value) * txt10.Value)
txt1.Value = ((8 * txt11.Value / txt3.Value) / (pi * txt2.Value)) - (4 * txt2.Value * txt2.Value / 3)

**Pepe Le Mokko** · 01-02-2014, 05:08 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.