Simple calculator build (have code) need help

[ExcelTheCell]

Well guys i'm not sure will you be able to help because this is code that i made in visual basic studio.. But i have found many similarity's between VBA in Excel and this one.

I'm tring to create simple calculator
textbox1 is number
textbox2 is agregate function (+ or - or * or /)
textbox3 is number
and textbox 4 gives result

here is the code:

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim number1 As Integer
        Dim number2 As Integer
        Dim Number3 As Integer
        Dim sign As String

        number1 = TextBox1.Text
        sign = TextBox2.Text
        number2 = TextBox3.Text
        Number3 = number1 & sign & number2
        TextBox4.Text = Number3

    End Sub
End Class

Example:
number1= integer = 1
sign= string = +
Number2= integer=2
Numberr=3

Anly idea??

 

[mole999]

not sure you can ADD with text

try

number2 = TextBox3.Text

as

number2 = TextBox3.value

 

[VoG]

Try

Private Sub CommandButton1_Click()
TextBox4.Value = Evaluate(Val(TextBox1.Text) & TextBox2.Text & Val(TextBox3.Text))
End Sub

N.B. no error check!!

 

[ExcelTheCell]

Tnx Vog that solved the problem...

[EDIT] oh no it isn't now what ever u write + or - or * it will give me result 3.. but we have some progress

 

[VoG]

You don't need to make it that complicated. Just right click the form, select View Code and enter the code that I posted here http://www.mrexcel.com/forum/showpost.php?p=2644492&postcount=3

You may want to put in some error checking (e.g. all the boxes must be filled etc.)