Displaying Excel Formulas Within Worksheet Cell Comments

Spreadsheets and graphs on a desk
xfgiro/istock

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.

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.

Replies

Please login or register to join the discussion.

avatar
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)
avatar
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)
avatar
Jun 16th 2017 18:46

I find this article very important as this is new for me. My daughter had just asked me how to use Macro in Excel. I did not have any idea. I will now share this article with my daughter. Thanks.

Thanks (0)
avatar
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)
avatar
Sep 19th 2017 13:07

For most of the calculation in business, people widely used the excel worksheets. It offers lots of advantages in calculations because the excel worksheet displaying formulas in cell comments. It helps to easily calculation of your values. Keep update more details here.discover travel

Thanks (0)
avatar
Oct 30th 2017 11:29

For any field of business, it is very necessary to know and learn about various excel tips. One such important and informative piece of writing is shared in this page and I found them really worth. I am new to the blog and hope you have more interesting topics discussed here.
http://paristoursnow.com/paris-city-tour/louvre-museum-tour/

Thanks (0)