Re: VBA Function to convert string to formula

From: David McRitchie (dmcritchie_at_msn.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 13:57:53 -0400

A lot of usage that wants to do this is actually trying to document
a formula. If that is the actual purpose then it would be better
to start from a working formula and leave it in place and to show
the contents of the formula in another cell i.e. GetFormula in
   http://www.mvps.org/dmcritchie/excel/formula.htm
That way there is not question that a function works. 

---
"Jan Karel Pieterse" <jkpieterse@netscape.net> wrote in message news:VA.000002e5.0109c4be@netscape.net...
> Hi Axel,
>
> > Since I don't get the evaluate function work on the *** (maybe linked
> > to Excel version 2002)
>
> Worked fine for my XL XP.
>
> > Function myFunct(InputString)
> > myFunct = Application.Evaluate("=" & InputString)
> > End Function
>
> You could include Application.Volatile and omit the 0*now bit.
>