doctorp
05-27-2013, 01:39 AM
I've seen a few tools around that deconstruct formulas into vba forms text boxes. Then you can evaluate each of the terms in the formula (usually with a hyperlink).
Example is here:
http://www.bestpracticemodelling.com/software/bpmtraverse
Does anyone know how to go about writing such code. I can build the form myself and all the finer points, but how exactly does one separate all the variables from the operators and brackets etc.
Any help would be welcomed.
Thanks:banghead:
Example is here:
http://www.bestpracticemodelling.com/software/bpmtraverse
Does anyone know how to go about writing such code. I can build the form myself and all the finer points, but how exactly does one separate all the variables from the operators and brackets etc.
Any help would be welcomed.
Thanks:banghead: