Click here to Skip to main content
15,891,943 members
Articles / General Programming / Parser

Math Expression Evaluator for VBA

Rate me:
Please Sign up or sign in to vote.
4.71/5 (4 votes)
1 Mar 2022GPL36 min read 11.2K   298   7  
A class module developed to evaluate mathematical expressions given as VBA strings
The VBAexpressions class serves as an intermediary between user interfaces and the main VBA/custom functions exposed through it. The main objective of the development of the class is to demonstrate that all mathematical expressions can be evaluated computationally using an approach similar to the one we humans use: divide the function into sub-expressions, create a symbolic string (lambda) to draw the evaluation flow of the expression, split the sub-expressions into chunks of operations (tokens) by tokenization, evaluate all the tokens.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The GNU General Public License (GPLv3)


Written By
Dominican Republic Dominican Republic
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions