Converting string into formula

[jcg31]

Is there a way in excel using VBA to convert string ( "A17*(B17+B18)/A18" ) into a executable formula?

Thanks,
Jim

 

[Trebor76]

Hi Jim,

The following will calculate and return the result of a string to a message box:

Sub Macro1()

    Dim strMyFormula As String
    
    strMyFormula = "A17*(B17+B18)/A18"
    
    MsgBox Evaluate(strMyFormula)

End Sub

Does that help?

 

[mikerickson]

If you have the string "A17*(B17+B18)/A18" in A1

and define a name Name: CalculatedValue RefersTo: Evaluate(Sheet1!$A$1)

putting =CalculatedValue in a cell will have the same effect as putting =A17*(B17+B18)/A18 in that cell.

 

[Mr_Roscoe]

Jim - should be able to try these:

Range("C18").Formula = "=A17*(B17+B18)/A18"

or

Range("C18").FormulaR1C1 = "=R[-1]C[-2]*(R[-1]C[-1]+RC[-1])/RC[-2]"

CHEERS, Ian R.