The formula usually starts off looking like this: "§1*2*3"
Thats what the variable 'Formula' will equal at the start, but then i use the Right command to get rid of my formula marker "§" so that its just "1*2*3"
each of the numbers is representing the Answer # that is going to be used. Thats where the first line comes in:VB Code:
MultNum(MyCount) = Left(Formula, 1)
Then i use it, and change it to the actual value of that answer, instead of the number of the question/answer that it is with:VB Code:
MultNum(MyCount) = frmNewProp.GridJobSpecCustom.TextMatrix(QRow, (MultNum(MyCount) * 2) - 1)
That can easily be changed to 1 line, but it was a quick fix and i just never changed it.
After it gets the first answer, it truncates the formula and goes through again and gets the multiplier, then truncates it again and gets the next answer, and so on until the formula is empty.




Reply With Quote