• Home
 · 
• Math/Dates
 · 
• Evaluate mathematical expressions in a few lines

Evaluate mathematical expressions in a few lines

Evaluate mathematical expressions in a few lines

API Declarations


' References: Microsft Excel Object Library
' If you dot include this referece the module will not work.



Rate Evaluate mathematical expressions in a few lines

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

    'Returns 0 if error in expression
    'Exxpression: Mathematical valid expression, z.B :  "23+(34/23*34)^2

    On Error GoTo errorHandle
   
    res = evaluate(expression)
    EvalExpresion = res
    Exit Function
    
errorHandle:
    expression = ""
    EvalExpresion = 0
End Function