VBA-Expressions v2.0.0

This new version includes many useful features, now VBA Expressions is shaping up to be a much more powerful tool.

Improvements

• VBA string, date-time and logical functions have been added (totaling more than 60 built-in functions).
• The evaluator now allows to define the value of a variable in terms of previously defined variables through the ImplicitVarValue property.
• Improved array handling mechanism.
• Added Solve and fZero functions.
• Refactoring: added VBAexpressionsScope class.
• Bug fixed: boolean negation prevents recognizing variables. Affected methods: Eval.

VBA-Expressions v1.0.1

Improvements:

• More advanced string manipulation behavior. It is now possible to evaluate string expressions as concat(concat('String1';'String2';'|');'String3';'+'). Note that Concat is a UDF function included to test the capabilities of our expression evaluator.
• The user can test the expression evaluator via a user form launched via a button from the Excel ribbon. This allows playing with the utility without the need to run Rubberduck unit tests.

VBA-Expressions v0.0.9

Bugs fixed:

• The system could not check for empty strings. Now users can check if a value is vbNullString using an expression like Date = ''.

VBA-Expressions v0.0.8

Bugs fixed:

• The value of PI cannot be retrieved for expressions that have multiple representations for this constant. (i.e.: 2.5mu^2+2u+2+COS(pi)*SIN(PI/2).

VBA-Expressions v0.0.7

Bugs fixed:

• Infinite loop when intercepting operators.

VBA-Expressions v0.0.6

• Bug fixed: unable to catch special cases when required to evaluate the like operator.

VBA-Expressions v0.0.5

• Improvement: LIKE operator ($) support. Now, expressions such as Region $ 'C?????? *a' can be evaluated successfully.

VBA-Expressions v0.0.4

• Improvement: ability to compare literal strings given in expressions.

VBA-Expressions v0.0.3

• Bug fixed: cannot get correct function name.
• Code update: removed redundant code.

VBA-Expressions v0.0.2

• Minor code and documentation improvements