Adding comments to a macro


show more Adding comments to a macro provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Adding comments to a macro

When you record or write an Excel macro, it's a good idea to put some information about the macro and what it's supposed to do in the code module where the macro was stored. You can do that by adding a comment. I'm going to work with the sample file called Comments. So I'll double-click. I do want to work with macros in this file - I'm expecting them, so I will click Enable macros. I now need to display the Developer tab of the Ribbon, so that I can use my Macro tools. Now that I'm here, I can click the Macros button.

Then in the Macro dialog box, I can click the macro that I want to work with, that I want to add a comment to. That will be Absolute. So I'll make sure it is selected here in the Macros pane. Then I will click Edit. When you open up a macro, you'll see several different kinds of text. In blue, for example, here with Sub, that is a structural note. In other words, it's about the structure of the routine. This is the start of the routine with S...

Adding comments to a macro
Video duration: 2m 43s 6h 32m Beginner

Viewers:

Adding comments to a macro provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...