![]() This will generate or open a ‘Customize’ pop-up window. Step 2: Click on View -> Toolbars -> Customize Step 3: From Customize Window Click on Commands -> Edit, then select Comment Block ![]() Select the statements in the macro/procedure that are required to be commented on below. So to do this, there is a built-in option of ‘Comment/Uncomment Block’ in VBE that is initially hidden in the toolbar and can be used as follows: Step 1: Select the Statements from code. In such a case, using an apostrophe before each statement would be quite tedious and time-taking when we have so many statements to comment on. Now, let’s say we wish to skip over and comment on an entire block of code, or multiple statements of the code. This method can also be used to comment on multiple lines by putting an apostrophe before each line as follows: Example #2 – Using Toolbar So, we see that when we wish to comment on a single line, it can simply be preceded with an apostrophe. So we can see in the above screenshot that on writing this code in the module, we see that when we simply put or insert an apostrophe before a statement/line, then that statement turns into green text and is considered as a comment. Now we can write our code or procedure in this module:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |