{"id":17245,"date":"2021-11-14T11:36:56","date_gmt":"2021-11-14T10:36:56","guid":{"rendered":"https:\/\/ekiwi-blog.de\/?p=17245"},"modified":"2021-11-14T11:36:56","modified_gmt":"2021-11-14T10:36:56","slug":"vba-comment-multiple-lines","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/17245\/vba-comment-multiple-lines\/","title":{"rendered":"VBA comment multiple lines"},"content":{"rendered":"

Anyone who programs a lot in the Microsoft Office area with VBA<\/abbr> and uses the associated VBA editor also wants to comment out entire blocks of code quickly.<\/p>\n

In some of our other posts we have described how to automatically process emails with macros when they arrive in the inbox. Or how to send e-mail attachments automatically to the printer. Such and other functions have to be tested a lot during development, and sometimes you want to comment whole methods and functions and then comment them back in.<\/p>\n

Unfortunately, VBA does not offer the possibility to comment the code as in other programming languages:<\/p>\n

\/*code line X<\/span>\r\ncode line Y<\/span>\r\ncode line Z*\/<\/span><\/code><\/pre>\n
Instead, in VBA you have to put the “apostrophe” in front of each line of code.<\/p>\n
'code line X<\/span>\r\n'code line Y<\/span>\r\n'code line Z<\/span><\/code><\/pre>\n
If you want to comment whole methods and functions, it can be very annoying to set or remove the “apostrophe” manually before each line.<\/p>\n
Comment code block in VBA<\/h2>\n
But fortunately, the VBA editor offers a corresponding function via a toolbar called “Edit”. However, this toolbar is not shown by default. To show it, go to View => Toolbars => Edit<\/strong><\/em> in the menu.<\/p>\n
\"Screenshot<\/a>
Show Toolbar Edit<\/figcaption><\/figure>\n
If the Edit toolbar appears floating in the program, you can also pin it to the existing toolbar.<\/p>\n
\"Screenshot<\/a>
Edit toolbar with buttons for comment and uncomment multiple lines (code block)<\/figcaption><\/figure>\n
There are now two icons here. One for commenting and one for uncommenting.<\/p>\n
To do this, mark the relevant lines of code and click on the respective symbol, as shown in the following two images. The “apostrophe” is then automatically prepended or removed for all marked lines.<\/p>\n
\"Screenshot<\/a>
Mark code lines and click button for “Comment Block”<\/figcaption><\/figure>\n
\"Screenshot<\/a>
Mark lines of code and click button for “Uncomment Block”<\/figcaption><\/figure>\n
So it is still possible to comment several lines in the VBA code in a halfway practicable way.<\/p>","protected":false},"excerpt":{"rendered":"
Anyone who programs a lot in the Microsoft Office area with VBA and uses the associated VBA editor also wants<\/p>\n","protected":false},"author":2,"featured_media":13630,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1555],"tags":[1701,1721,1702,1857,1704,2168,1700,1861,1705,1706,1710],"class_list":["post-17245","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-access-en","tag-comment","tag-excel-en","tag-microsoft-en-2","tag-microsoft-office-en","tag-office-en","tag-programming","tag-vba-en-2","tag-vba-en","tag-visual-basic-for-application-en","tag-word-en"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/17245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/comments?post=17245"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/17245\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media\/13630"}],"wp:attachment":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media?parent=17245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=17245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=17245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}