We can't offer VBA support on these forums, but there is an undocumented way to do this without using VBA.
There is a 'secret' EVALUATE function that can only be accessed by creating a range name. If you're not sure how to do this, you can find an explanation in the video lesson: Expert Skills Lesson 4-2 Manually create single cell range names and named constants.
For example, to execute a formula that is stored as text in cell A1, you could define the following range name:
The EVALUATE function will not work if you try entering it as a cell formula. It can only be accessed by creating a range name in this way.
After creating the range name, you can extract the result with the formula: =EvaluateResult
Note that, even though this doesn't appear to be a macro, it will actually cause Excel to run a macro 'behind the scenes'. This means that it will only work within a macro-enabled workbook.
I have attached a working example:
Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.