Evaluate Mathematical Expressions Passed As A String

This code will return 11 from the string "(2 * 3) + 5"

Preparations

Add Microsoft Script Control to your Form. (choose Project->Components, check the Microsoft Script Control CheckBox and Press OK. Then add the control to your form).

If you don't have this control, you can download it from http://msdn.microsoft.com/scripting/

Form Code

Private Sub Form_Load()
    'replace the "(2 * 3) + 5" with the string you want to evaluate
   
MsgBox (ScriptControl1.Eval("(2 * 3) + 5"))
End Sub

Go Back