I gave up so I tried another approach... I found an unused cell in the
active worksheet and updated that empty cell with the formula and set
the font to match the background so it would not appear to the user
that a cell got changed. I was planning to then reference this cell
and set the value of my control on the form equal to the value of the
cell, BUT!!! as usual.... something else went wrong. I am using
Refedit controls on a form and the refedit change events are not
firing. I see this is YET another bug in the refedit control. After
trying to be a bit creative with several other events, I could still
not get around these refedit bugs. Now I am very frustrated...

Anyway, assuming my above circumvention idea would have worked, I
believe it would have been a bad programming practice to do because my
code can be used from any workbook and if it used on a workbook that
has code in certain worksheet events, then that could create many
possible problems and thats not something I want to do.

So now I am back to square one.... and that is to figure out how in
the world to use the application.evaluate method to return my result
on my formula stored in a large string with various variables
comprising it. Any suggestions????