Hi VB Gurus (I hope),

I want to create a function that can execute a formula that gets passed in as a parameter. In VFP, I can simply use the EVAL function or if necessary, the ill spoken macro substitution character.

In VFP my code would look something like this:

nValueA = 2
nValueB = 3
nValueC = 6
cCalcString = "(nValueA + nValueB) * nValueC"

nResult = EVAL(cCalcString) && nResult is 30

How would I do this in VB? And please don't suggest that I hard-code the formula - there's about 100 of them and I don't think it makes sense to code 100 separate functions that all do basically the same thing.

Thanks for your help!

-JT