Show formula!

[Ingolf]

Hallo!

I put a formula in cel A1 an I need a formula to write that formula from A1 in another cell, let say D1. Formula as a text not, result o a formula.
It is posibil a formula or I need VBA code.

Let say in A1 is =Vlookup(...,....,...,.) and I need D1 text Vlookup(.....

Thanks

 

[Jonmo1]

You need VBA code for that...

Try this UDF

Function FormulaText(c As Range) As String
If c.HasFormula Then
    FormulaText = c.Formula
Else
    FormulaText = ""
End If
End Function

Then use it like this in a cell

=FormulaText(A1)

Whatever formula is in A1 will be displayed as this formula's result

 

[Ingolf]

Thank you so much.