MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Display formula in a cell


Posted by Rich Allwes on January 08, 2002 9:05 AM

Is there an existing macro or formula for displaying the formula contained in a cell in another cell.

For example: The number 25 is displaced in cell A3.

I want to list the formula "=3*gamma-beta of cell A3 in cell B3. Gamma and beta are range names of cells.

I would appreciate help in this matter.


Posted by Andy Gee on January 08, 2002 9:25 AM

Why not just type it then format it as text!

Posted by Dat on January 08, 2002 10:15 AM

Push---- Ctrl + ~ at the same time (~ is under the Esc key)

Posted by Chris D on January 08, 2002 10:31 AM

Would you want the displayed formula to change if you changed the original formula, without having to do any typing or anything ?

If you do, I have a very cumbersome non-macro fix which I'm sure can be put to shame by the VBA guys on this site...

If not, then the suggestions below would be what I'd do...

give me a shout
Chris

Posted by Stephen Giles on January 09, 2002 6:29 AM

This code will show the formula in an individual cell:
Function CellFormula(c)
CellFormula = c.Formula
End Function

Press alt+F11, insert a module and paste in the code. If say you want to see the formula in A1, enter =cellformula(A1) in another cell and that formula will appear.