Display a cell formula

Folks,
Doesn't Excel 2013 have a function that displays a formula in a cell?
Also, in the display I created a function "getformula" and tried to make it available to any new worksheet. Guess what - I failed. Where does that macros need to be stored? I got a #Name error when I tried to use it.
getformula.png
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
Any particular reason that you want to see the formula..??

If you just intrested to see the formula for short time that you can try using

ctrl+~ what does that do..It shows all the formulas written as a text rather then formula answer..

Once you have seen the formulas and checked them you can again press ctrl+~ it will now show you the answer rather then the formula...
0
Martin LissOlder than dirtCommented:
How did you attempt to use that function?
0
Wilder1626Commented:
Hi
Something must be wrong on your end.

Look at my attachment. It is working. Can you try it with my excel file?
Get-formula.xlsm
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

barry houdiniCommented:
In Excel 2013 there is a worksheet function FORMULATEXT

So if I put this formula in A1

=SUM(A2:A10)

and then in B1 I use

=FORMULATEXT(A1)

that returns a text value "=SUM(A2:A10)"

regards, barry
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
Expert Comment
Saurabh Singh Teotia:
I'm refining an Excel study workbook and I find it easier to refer back to an example and see the formula
Martin Liss:
Only to display the formula and that it.
Jean-Marc;
I'm looking at your now
0
Frank FreeseAuthor Commented:
Barry,
Great...I knew there was a 2013 function.
Folks,
I'll post another question on the proper way to share a macro for all new workbooks going forward. The reason for this is only 2013 has the FormulaText() function.What I showed above in my post was a macro GetFormula that was place in VBA Project(Personal.XLSB) under modules. I did not get the results I was expecting.
I other words, a macro that I can have available, if needed, in a new workbook.
0
Frank FreeseAuthor Commented:
thanks Barry
0
Frank FreeseAuthor Commented:
Jean-Marc (Wilder1626)
I noticed where you created a new function call GetFormula in the function lists. Do you mind responding to my open question with how you did that. That's a  great alternative.
FRank
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.