Re: VBA Function to convert string to formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jan Karel Pieterse (jkpieterse_at_netscape.net)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 13:30:42 +0200

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.

> Maybe I should take off for
> the rest of the day... :-)

You have my permission <bg>.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Quantcast