userform textbox calculation

[viruzman]

Hello

I Have a Userform that has 4 textboxes on it.


Control Value
textbox1 2
textbox2 +
textbox3 3
textbox4 Results

so basicly textbox2 will give me the sum of textbox1 + textbox3 = textbox4.text = 5 wich is the results.

usually the formula or vba i use is

textbox4 = VAL(textbox1) + VAL(Textbox3)
but i need something like
textbox4 = Val(textbox1) And VAL(textbox2) + VAL(textbox3)

[mikerickson]

This userform code assumes four text boxes,

TextBox1 holds a numeral
TextBox2 holds a symbol; + - * / ^
TextBox3 holds a numeral

TextBox4 will display the result of the calculation.

Please Login or Register  to view this content.

[shg]

Another option:

Please Login or Register  to view this content.

[mikerickson]

Nice!

I need to remember Evaluate.