How to show the formula of another cell

[Guest]

Hi

I want to show the content (formula) of another cell. For instance, if the
formula in A1 is =2*12, I want cell B1 to show =2*12 instead of the answer
(24). In other words i want the answer as usual (24) in A1, and in B1 I want
the formula of A1 to be showed (=12*2).

I am not interested in showing all of the formulas in the sheet, like you
can do with tools/options/view/formulas.

Please help!

 

[Arvi Laanemets]

Hi

You can use this UDF:

Public Function ShowFormula(MyCell As Range)
ShowFormula = MyCell.Formula
End Function

Copy the function into workbook module. After that, you can use it in this
workbook as any other formula. P.e. into B1 enter
=ShowFormula(A1)

 

[Guest]

Thanks, that solved the problem. By the way, is it not possible to do this
without a UDF?