More variable issues

About the first problem I came here with...using variables in equations. Well the calculation you gave me for Equator was:

With Equator1
txtStrengthCalc = UCase(txtStrengthCalc)
.Equation = Replace(txtStrengthCalc, "STR", CStr(iStr))
.Calculate
txtStrength = .Result

That works fine for strength and all, but say, if I wanted to calculate using other variables in this, like str*agi, or str/vit, etc, it won't recognize the variable and assigns it a value of zero. How do I get ALL equations I run to recognize ALL variables?

It will be hard. You will have to add a Replace line for every variable.
Dim strTemp as String
strTemp = UCase(txtStrengthCalc)
strTemp = Replace(txtStrengthCalc,"STR",CStr(iStr))
strTemp = Replace(strTemp,"AGI",CStr(agi))
strTemp = Replace(strTemp,"VIT",CStr(vit))
...
.Equation = strTemp
This is still easier than writing a full parser.

I think therefore I am... sometimes right. images/icons/wink.gif

I had tried something like that but not QUITE like the way you did it. It works now...thanks.