Function to display formula in specified cell

[Robert E. Leonard Sr]

I am trying to display in a spreadsheet, the formula in an adjent cell. Any
suggestions?

EXAMPLE:

cell A2 contain formula: =Mid(c3,5.2)

In cell B2 i would like to insert a formula displaying above formula.

I know that I can copy the formula to cell B2 and save as text by inserting
a space before = sign. What I am looking for is an automatic fix.

Thanks, for your help
Bob Leonard
(e-mail address removed)

 

[RagDyer]

This old post describes how to create a formula to do what you're looking
for:

http://tinyurl.com/y5tckh

 

[Bernard Liengme]

Here is the UDF I use for documention
Function ShowFormula(MyCell)
ShowFormula = MyCell.Address & " " & MyCell.Formula
End Function
best wishes