Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show a cell's formula in text format in a linked cell
I want to show the formula for a specific cell in text format in another cell.
For example, if cell A1 has a simple formula of "=10+64" (but only shows an answer of "74"), how can i link this cell to B1, so that B1 only shows as text "10+64" or " =10+64", instead of the actual answer? |
#2
|
|||
|
|||
On Sun, 27 Jan 2013 23:28:44 +0000, TreeHugger1 wrote:
I want to show the formula for a specific cell in text format in another cell. For example, if cell A1 has a simple formula of "=10+64" (but only shows an answer of "74"), how can i link this cell to B1, so that B1 only shows as text "10+64" or " =10+64", instead of the actual answer? You can do this with a User Defined Function (UDF). To enter this User Defined Function (UDF), <alt-F11 opens the Visual Basic Editor. Ensure your project is highlighted in the Project Explorer window. Then, from the top menu, select Insert/Module and paste the code below into the window that opens. To use this User Defined Function (UDF), enter a formula like =showformula(A1) in B1. ====================== Function ShowFormula(rg As Range) As String ShowFormula = rg.Formula End Function ======================= |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
Formula to recognize if another cell's conditional format is true | Excel Discussion (Misc queries) | |||
Why does formula show rather than results (not in text format) | Excel Worksheet Functions | |||
how to get the formula shown in linked cell's names | Excel Programming | |||
How do I use a cell's text, "A1", and put it in a formula? | Excel Worksheet Functions |