{"id":3419,"date":"2021-06-20T14:52:33","date_gmt":"2021-06-20T21:52:33","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3419"},"modified":"2021-06-20T14:52:34","modified_gmt":"2021-06-20T21:52:34","slug":"how-to-comment-un-comment-a-block-in-office-vba-editor","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3419","title":{"rendered":"How to Comment &#038; Un-comment a Block in  Office VBA Editor"},"content":{"rendered":"\n<p>Being able to comment a block of code is a standard operation in any IDE, but for some reason the Microsoft Office VBA Editor does not include that functionality by default. However, the functionality is there and waiting to be used, it\u2019s just hidden in the \u201cEdit\u201d toolbar which is not visible be default.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to comment a block of code in the Office VBA Editor\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/xNNL7C7Q2C0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<ol class=\"wp-block-list\"><li>Open the VBA Editor (Alt + F11).<\/li><li>Right click anywhere on the toolbar.<\/li><li>Select the \u201cEdit\u201d Toolbar.<br><a href=\"https:\/\/tachytelic.net\/wp-content\/uploads\/VBA-Edit-Toolbar.png\"><\/a><\/li><li>You will now be able to quickly and easily comment a block of code (or uncomment) using these new buttons on your toolbar:<br><a href=\"https:\/\/tachytelic.net\/wp-content\/uploads\/VBA-Comment-and-Uncomment-Blocks-of-Code.png\"><\/a><\/li><li>Done!<\/li><\/ol>\n\n\n\n<p>Hope this helps!<\/p>\n\n\n\n<p>Ref: https:\/\/www.tachytelic.net\/2018\/11\/how-to-comment-a-block-of-code-in-the-microsoft-office-vba-editor\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Being able to comment a block of code is a standard operation in any IDE, but for some reason the Microsoft Office VBA Editor does not include that functionality by default. However, the functionality is there and waiting to be used, it\u2019s just hidden in the \u201cEdit\u201d toolbar which is not visible be default. Open <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3419\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[772,771],"class_list":["post-3419","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-comment-a-block-in-excel-vba","tag-comment-a-block-in-vba"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3419"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3419\/revisions"}],"predecessor-version":[{"id":3421,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3419\/revisions\/3421"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}