Displaying Excel Formulas Within Worksheet Cell Comments

Spreadsheets and graphs on a desk

Several years ago I developed a proprietary tool that enables me to instantly display Excel formulas in a formatted cell comment. I’ve gotten asked about this concept often enough that in this article I’ll explain how you can create a “lite” version of my tool.

We’ll start the process by way of Excel’s Macro Recorder so that the macro can be placed in your Personal Macro Workbook. This macro requires programming code that cannot be recorded, so we’ll only turn the macro recorder on and off to create an initial shell for the programming code that you’ll copy and paste later on in this article.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

By ccurran
Mar 8th 2017 17:32

Thanks for this. The only question is regarding the 5 lines of code displayed after "On Error GoTo 0" in Figure 4. These are not discussed in the article and are not necessary for the macro to work. Can you explain these 5 lines of code? Maybe they are from your "full" version of the macro?

Thanks (0)
Apr 17th 2017 10:31

The accounting advisor David ringstorm tells Computer Science Assignment Help guide in a proper way about excel file through this accounting web site.

Thanks (0)
Aug 23rd 2017 22:04

Excel sheet is very useful for making any work update sheet because they're user easily use column and raw relate to his/her work even most of the employ any strategy on it so they easily use mention that work with date by which another person understand freely. And those students study in college or university, so they have to use it for managing their time excel and PPT for making presenting and teachers provide final assignment to those students who desire to get a life experience degree accredited by the us department of education in their desire faculty by which to grow in their desire industry without any problem.

Thanks (0)