Thanks for the help. I've resolved my initial issues. Based on the Google research, I got the impression that Evaluate only works with cell references and will not work with VBA fields. So, I updated a temp cell with my initial value from the "value" field, then used the EVALUATE reading my original formula Text cell. So, final answer is:
1. Formula Cell = sum(Temp!$AA$1 * -1)
This has the reference to my temporary holding cell AA1 on TEMP worksheet.
2. VBA Code =
ActiveCell.value = value
value = Evaluate(FldCalc(cnt))
FldCalc is a Collection where I'm storing the text formulas.
What I'm hoping now, is that I can put almost any Excel or VBA formula into my Formula column and have it execute. But, I expect to have to tweek it as I go.
Again, thanks for the input.