"((3+5)*4)-(40/2)-10)" =????

[Phogang]

When user enter any string on TextBox like... "((3+5)*4)-(40/2)-10)".
how to make my program give the numerical result from the string.

[aio]

Add 'Microsoft Access 8.0 Object Library' to your project's reference and this code:

private Sub Command1_Click()
  Text1.Text = "((3+5)*4)-(40/2)-10)"
  MsgBox Eval(Text1.Text)
End Sub

[MKSa]

'Add the Microsoft Script Control to your form and use the Eval function.
private Sub Command1_Click()
Debug.print ScriptControl1.Eval(Text1)
End Sub