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.
About David Ringstrom, CPA
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.