{"id":11393,"date":"2022-09-11T19:52:01","date_gmt":"2022-09-11T10:52:01","guid":{"rendered":"https:\/\/prodskill.com\/?p=11393"},"modified":"2022-10-11T11:42:51","modified_gmt":"2022-10-11T02:42:51","slug":"excel-vba-lecture-9-how-to","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/","title":{"rendered":"Excel VBA Courses (9): Excel VBA How-To"},"content":{"rendered":"<p>This article examines the Excel VBA How-To. Please refer to it when coding Excel VBA.<\/p>\n\n\n\n<p>This is a continuation of the previous article.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-8-datatype\/\">Excel VBA Course (8): Excel VBA Language Basics - Data Types, Data Structures<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#4_%EC%97%91%EC%85%80_VBA_How-To\" >4. Excel VBA How-To<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#41_UIUser_Interface_%EA%B5%AC%EC%84%B1_%EB%B0%A9%EB%B2%95\" >4.1. How to configure UI (User Interface)<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#411_%EC%97%91%EC%85%80_Sheet%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\" >4.1.1. UI using Excel Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#412_User_Form%EC%9D%84_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\" >4.1.2. UI using User Form<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#412_Ribbon_Bar%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\" >4.1.2. UI using Ribbon Bar<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#42_VBA_%EC%BD%94%EB%93%9C%EB%A5%BC_%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\" >4.2. How to run VBA code<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#421_%EB%B2%84%ED%8A%BC_%ED%81%B4%EB%A6%AD_%EC%9D%B4%EB%B2%A4%ED%8A%B8%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\" >4.2.1. Fire on button click event<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#422_%EC%8B%A4%ED%96%89%ED%95%A0_%EC%86%8C%EC%8A%A4%EC%BD%94%EB%93%9C%EC%97%90_%EC%BB%A4%EC%84%9C_%EC%9C%84%EC%B9%98%EC%8B%9C%ED%82%A4%EA%B3%A0_%EB%8B%A8%EC%B6%95%ED%82%A4%EB%A1%9C_%EC%8B%A4%ED%96%89\" >4.2.2. Place the cursor on the source code to be executed and execute it with a shortcut key<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#423_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\" >4.2.3. Run in the Immediate Window<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#43_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >4.3. How to use the Immediate Window tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#44_%EA%B0%9C%EC%B2%B4_%EC%B0%BE%EC%95%84%EB%B3%B4%EA%B8%B0_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >4.4. How to use the object browse tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#45_VBA_%EC%84%B1%EB%8A%A5_%ED%96%A5%EC%83%81_%EB%B0%A9%EB%B2%95\" >4.5. How to improve VBA performance<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#46_%EB%A7%A4%ED%81%AC%EB%A1%9C_%EA%B8%B0%EB%A1%9D%EA%B8%B0_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >4.6. How to use the macro recorder<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/#47_%EC%BD%94%EB%94%A9%EC%8B%9C_%EC%A7%80%ED%82%A4%EB%A9%B4_%EC%A2%8B%EC%9D%84_%EA%B8%B0%EB%B3%B8_%EC%9B%90%EC%B9%99\" >4.7. Basic principles to follow when coding<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"4._\uc5d1\uc140_VBA_How-To\"><span class=\"ez-toc-section\" id=\"4_%EC%97%91%EC%85%80_VBA_How-To\"><\/span>4. Excel VBA How-To<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.1._UI(User_Interface)_\uad6c\uc131_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"41_UIUser_Interface_%EA%B5%AC%EC%84%B1_%EB%B0%A9%EB%B2%95\"><\/span>4.1. How to configure UI (User Interface)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In Excel VBA, there are three ways to configure the UI, such as receiving values from the user or showing the progress.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4.1.1._\uc5d1\uc140_Sheet\ub97c_\uc0ac\uc6a9\ud55c_UI\"><span class=\"ez-toc-section\" id=\"411_%EC%97%91%EC%85%80_Sheet%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\"><\/span>4.1.1. UI using Excel Sheet<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>This is the most common method. Add controls such as buttons, text boxes, and check boxes to the Excel Sheet and handle events. It is the easiest to implement and convenient to use as you can click a button while looking at the data.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96.png\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"358\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96.png\" alt=\"\uc5d1\uc140 Sheet\ub97c \uc0ac\uc6a9\ud55c UI\" class=\"wp-image-11394\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96.png 345w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-289x300.png 289w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-12x12.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-36x36.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-46x48.png 46w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><figcaption>UI using Excel Sheet<\/figcaption><\/figure>\n<\/div>\n\n\n<p>This method has one drawback. If you click a button after the screen resolution is changed, the size of the button continues to increase or the size of the text decreases. Mainly, when the external monitor is changed or connected to a beam projector, the screen resolution is changed, and this phenomenon almost always occurs if the excel sheet containing the control is open at that time. This phenomenon occurs when an ActiveX control is used and does not occur when a form control is used.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97.png\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"307\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97.png\" alt=\"\uc591\uc2dd \ucee8\ud2b8\ub864\uacfc ActiveX \ucee8\ud2b8\ub864\" class=\"wp-image-11395\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97.png 647w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-300x142.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-36x17.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-48x23.png 48w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/a><figcaption>Form controls and ActiveX controls<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"4.1.2._User_Form\uc744_\uc0ac\uc6a9\ud55c_UI\"><span class=\"ez-toc-section\" id=\"412_User_Form%EC%9D%84_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\"><\/span>4.1.2. UI using User Form<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>This is a method of handling events by creating a separate UserForm object and adding controls to it.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98.png\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"358\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98.png\" alt=\"User Form\uc744 \uc0ac\uc6a9\ud55c UI\" class=\"wp-image-11396\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98.png 345w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-289x300.png 289w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-12x12.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-36x36.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-46x48.png 46w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><figcaption>UI using User Form<\/figcaption><\/figure>\n<\/div>\n\n\n<p>It may not be suitable for working while inputting\/modifying data, such as a list of input values, as it may cover the screen. As shown in the figure below, it is suitable for displaying information such as ProgressBar.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99.png\"><img loading=\"lazy\" decoding=\"async\" width=\"439\" height=\"123\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99.png\" alt=\"Progress Bar UI\" class=\"wp-image-11397\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99.png 439w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-300x84.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-48x13.png 48w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption>Progress Bar UI<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"4.1.2._Ribbon_Bar\ub97c_\uc0ac\uc6a9\ud55c_UI\"><span class=\"ez-toc-section\" id=\"412_Ribbon_Bar%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\"><\/span>4.1.2. UI using Ribbon Bar<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>This is the most labor intensive and complicated method. Add custom tabs and buttons to the Ribbon Bar interface, which has been changed since Excel 2007, and handle events. Here is an example of a custom Ribbon Bar that a junior employee made and sent to me a few years ago.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"319\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\" alt=\"Ribbon Bar\ub97c \uc0ac\uc6a9\ud55c UI\" class=\"wp-image-11398\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png 392w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-300x244.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-48x39.png 48w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><figcaption>UI using Ribbon Bar<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Data Standards Checking Tool (* Note: <a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-toc\/\">Data Standard Check Tool Description Contents , Download<\/a>) provided the UI in Excel Sheet, but if you change it to Ribbon bar UI, it will be similar to the above.<\/p>\n\n\n\n<p>The content of the ribbon bar is quite extensive on its own, so I will organize it in a separate article later. See below.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/archive\/msdn-magazine\/2007\/february\/extend-office-2007-with-your-own-ribbon-tabs-and-controls\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/archive\/msdn-magazine\/2007\/february\/extend-office-2007-with-your-own-ribbon-tabs-and-controls<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/library-reference\/concepts\/overview-of-the-office-fluent-ribbon\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/library-reference\/concepts\/overview-of-the-office-fluent-ribbon<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.2._VBA_\ucf54\ub4dc\ub97c_\uc2e4\ud589\ud558\ub294_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"42_VBA_%EC%BD%94%EB%93%9C%EB%A5%BC_%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\"><\/span>4.2. How to run VBA code<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There are at least three ways to run VBA code.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4.2.1._\ubc84\ud2bc_\ud074\ub9ad_\uc774\ubca4\ud2b8\uc5d0\uc11c_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"421_%EB%B2%84%ED%8A%BC_%ED%81%B4%EB%A6%AD_%EC%9D%B4%EB%B2%A4%ED%8A%B8%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\"><\/span>4.2.1. Fire on button click event<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101.png\"><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"358\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101.png\" alt=\"\ubc84\ud2bc \ud074\ub9ad \uc774\ubca4\ud2b8\uc5d0\uc11c VBA \ucf54\ub4dc \uc2e4\ud589\" class=\"wp-image-11399\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101.png 762w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-300x141.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-520x245.png 520w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-36x17.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-48x23.png 48w\" sizes=\"auto, (max-width: 762px) 100vw, 762px\" \/><\/a><figcaption>Run VBA code on button click event<\/figcaption><\/figure>\n<\/div>\n\n\n<p>This is how to create a button as shown in the figure above and write a statement that executes VBA code in the click event of the button. This is suitable when providing a way to run it in the UI.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4.2.2._\uc2e4\ud589\ud560_\uc18c\uc2a4\ucf54\ub4dc\uc5d0_\ucee4\uc11c_\uc704\uce58\uc2dc\ud0a4\uace0_\ub2e8\ucd95\ud0a4\ub85c_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"422_%EC%8B%A4%ED%96%89%ED%95%A0_%EC%86%8C%EC%8A%A4%EC%BD%94%EB%93%9C%EC%97%90_%EC%BB%A4%EC%84%9C_%EC%9C%84%EC%B9%98%EC%8B%9C%ED%82%A4%EA%B3%A0_%EB%8B%A8%EC%B6%95%ED%82%A4%EB%A1%9C_%EC%8B%A4%ED%96%89\"><\/span>4.2.2. Place the cursor on the source code to be executed and execute it with a shortcut key<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102.png\"><img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"323\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102.png\" alt=\"\ucee4\uc11c \uc704\uce58\uc5d0\uc11c VBA \ucf54\ub4dc \uc2e4\ud589\" class=\"wp-image-11400\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102.png 396w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-300x245.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-48x39.png 48w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/a><figcaption>Run VBA code at cursor position<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Place the cursor on the Sub or Function procedure code in VBE (Visual Basic Editor) and press the shortcut key.&nbsp;<strong>F5<\/strong>run with You can also click the run button (\u25b6\ufe0f) on the toolbar. This method only works for Sub and Function procedures without parameters.<\/p>\n\n\n\n<p>This method is suitable for simple testing when there is no need to externally provide an execution method.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"423_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\"><\/span>4.2.3. Run in the Immediate Window<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103.png\"><img loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"380\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d\uc5d0\uc11c VBA \ucf54\ub4dc \uc2e4\ud589\" class=\"wp-image-11401\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103.png 465w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-300x245.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-48x39.png 48w\" sizes=\"auto, (max-width: 465px) 100vw, 465px\" \/><\/a><figcaption>Running VBA code in the Immediate Window<\/figcaption><\/figure>\n<\/div>\n\n\n<p>This method is to enter the name and parameter of a Sub or Function procedure in the Immediate Execution window and press the Enter key to execute it. This method is suitable for simple testing of Sub and Function procedures with parameters.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.3._\uc9c1\uc811_\uc2e4\ud589_\ucc3d_\ub3c4\uad6c_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"43_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>4.3. How to use the Immediate Window tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The Immediate Execution window can be used for a variety of purposes, such as debugging and message output, in addition to macro execution as discussed above.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104.png\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"524\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95\" class=\"wp-image-11402\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104.png 894w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-300x176.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-768x450.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-48x28.png 48w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/a><figcaption>How to use the Immediate Window tool<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\"><li>run macro<ul><li>Execute by entering the name of the sub or function procedure in the module<\/li><li>Procedures with parameters can also be executed<\/li><\/ul><\/li><li>Check variable values at run time<ul><li>Used while stopping at a breakpoint<\/li><li>Print or ? After entering the variable name, confirm the value with the Enter key.<\/li><\/ul><\/li><li>Check output message<ul><li>Check the output with Debug.Print<\/li><\/ul><\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.4._\uac1c\uccb4_\ucc3e\uc544\ubcf4\uae30_\ub3c4\uad6c_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"44_%EA%B0%9C%EC%B2%B4_%EC%B0%BE%EC%95%84%EB%B3%B4%EA%B8%B0_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>4.4. How to use the object browse tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>previous post&nbsp;<a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-3\/\">Excel VBA Course (3): Excel Object Model<\/a>&nbsp;I took a quick look at the object browse tool in .<\/p>\n\n\n\n<p>Execute &#039;Browse Object&#039; in the VBE &#039;View&#039; menu. Shortcut is&nbsp;<strong>F2<\/strong>&nbsp;am.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105.png\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"431\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \uba54\ub274\" class=\"wp-image-11403\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105.png 695w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-300x186.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-48x30.png 48w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><figcaption>object browse menu<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The object browsing tool is composed of the following.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106.png\"><img loading=\"lazy\" decoding=\"async\" width=\"765\" height=\"515\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \uad6c\uc131\" class=\"wp-image-11404\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106.png 765w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-300x202.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-36x24.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-48x32.png 48w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/a><figcaption>Configuring the object browse tool<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\"><li>Filter &amp; Search<ul><li>You can check the list of all libraries that are provided by default in Excel and libraries that have been added as references, and select a specific library.<\/li><li>The entire library list can be searched by class name or member name.<\/li><\/ul><\/li><li>class list<ul><li>Shows a list of all classes, modules, and enums under the selected library.<\/li><\/ul><\/li><li>member list<ul><li>Shows the list of procedures, functions, properties, etc. that are members of the class or module selected in the class list.<\/li><\/ul><\/li><li>member information<ul><li>Shows the details of the procedure, function, property, etc. selected from the member list.<\/li><\/ul><\/li><\/ol>\n\n\n\n<p>The types of icons displayed in the object search tool and their meanings are as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107.png\"><img loading=\"lazy\" decoding=\"async\" width=\"502\" height=\"672\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c\uc5d0\uc11c \ud45c\uc2dc\ub418\ub294 \uc544\uc774\ucf58\uc758 \uc885\ub958\uc640 \uc758\ubbf8\" class=\"wp-image-11405\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107.png 502w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-224x300.png 224w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-9x12.png 9w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-18x24.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-27x36.png 27w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-36x48.png 36w\" sizes=\"auto, (max-width: 502px) 100vw, 502px\" \/><\/a><figcaption>Types and Meanings of Icons Displayed in the Object Browse Tool<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(source:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/icons-used-in-the-object-browser-and-code-windows\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/icons-used-in-the-object-browser-and-code-windows<\/a>)<\/p>\n\n\n\n<p>For more information on the object browse tool, refer to the URL below.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/object-browser\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/object-browser<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.5._VBA_\uc131\ub2a5_\ud5a5\uc0c1_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"45_VBA_%EC%84%B1%EB%8A%A5_%ED%96%A5%EC%83%81_%EB%B0%A9%EB%B2%95\"><\/span>4.5. How to improve VBA performance<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>How to improve VBA performance is written in a separate article.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/\">VBA Coding Patterns: Improving VBA Performance<\/a><\/p>\n\n\n\n<p>To summarize the above article, set the global variable to a performance improvement value before entering the code to be processed, and change it to the original value after the processing code is finished. Please refer to the following code.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'\ucf54\ub4dc \uc9c4\uc785 \ubd80\ubd84\nApplication.ScreenUpdating = False\nApplication.Calculation = xlCalculationManual\nApplication.EnableEvents = False\nApplication.DisplayAlerts = False\n\u00a0\n'\uc2e4\ud589\ud560 \ucf54\ub4dc\uac00 \ub4e4\uc5b4 \uac08 \ubd80\ubd84\n...\n\u00a0\n'\ucf54\ub4dc \uc885\ub8cc \ubd80\ubd84\nApplication.ScreenUpdating = True\nApplication.Calculation = xlCalculationAutomatic\nApplication.EnableEvents = True\nApplication.DisplayAlerts = True<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.6._\ub9e4\ud06c\ub85c_\uae30\ub85d\uae30_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"46_%EB%A7%A4%ED%81%AC%EB%A1%9C_%EA%B8%B0%EB%A1%9D%EA%B8%B0_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>4.6. How to use the macro recorder<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel&#039;s macro recorder is very useful. For example, if you&#039;re creating a new pivot table, a new chart, or don&#039;t know how to write repetitive tasks in VBA code, the macro recorder can be of great help.<\/p>\n\n\n\n<p>If you start the macro recorder, process a task using the keyboard or mouse, and then stop the macro recorder, you can see that the details of the work processed so far are written in VBA code. It is possible to code much faster and more accurately by modifying and using the code created in this way than writing VBA code from scratch.<\/p>\n\n\n\n<p>Macro recording starts by clicking the &#039;Record Macro&#039; button on the Developer tab or the bottom status bar as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108.png\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"241\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d \uc2dc\uc791 \ubc84\ud2bc\" class=\"wp-image-11406\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108.png 708w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-300x102.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-24x8.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-36x12.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-48x16.png 48w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/a><figcaption>Start macro recording button<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you click the &#039;Record Macro&#039; button, a window to enter the macro name, shortcut key, save location, and description appears as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109.png\"><img loading=\"lazy\" decoding=\"async\" width=\"350\" height=\"327\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109.png\" alt=\"\ub9e4\ud06c\ub85c \uc774\ub984, \ubc14\ub85c \uac00\uae30 \ud0a4, \uc800\uc7a5 \uc704\uce58 \uc124\uc815\" class=\"wp-image-11407\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109.png 350w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-300x280.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-13x12.png 13w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-24x22.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-36x34.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-48x45.png 48w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/a><figcaption>Set macro name, shortcut key, storage location<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you click the &#039;OK&#039; button after entering the macro information, the recording state is changed as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110.png\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"241\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d \uc911\" class=\"wp-image-11408\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110.png 713w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-300x101.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-24x8.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-36x12.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-48x16.png 48w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/a><figcaption>recording macro<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Let&#039;s record the pasted data&#039;s border designation, Header setting (background color, font, center alignment), grid line hiding, and freeze frame functions with the macro recorder. If you start macro recording and execute the function using the keyboard or mouse, the result is as shown on the right side of the figure below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111.png\"><img loading=\"lazy\" decoding=\"async\" width=\"734\" height=\"443\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d \uc608\uc2dc\" class=\"wp-image-11409\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111.png 734w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-300x181.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-48x29.png 48w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/a><figcaption>Macro record example<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Stop macro recording and check the generated VBA code as follows.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Sub \ub9e4\ud06c\ub85c1()\n'\n' \ub9e4\ud06c\ub85c1 \ub9e4\ud06c\ub85c\n'\n    Columns(\"A:B\").Select\n    Columns(\"A:B\").EntireColumn.AutoFit\n    Range(\"A1:B11\").Select\n    Selection.Borders(xlDiagonalDown).LineStyle = xlNone\n    Selection.Borders(xlDiagonalUp).LineStyle = xlNone\n    With Selection.Borders(xlEdgeLeft)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlEdgeTop)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlEdgeBottom)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlEdgeRight)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlInsideVertical)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlInsideHorizontal)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    Range(\"A1:B1\").Select\n    Selection.Font.Bold = True\n    With Selection\n        .HorizontalAlignment = xlCenter\n        .VerticalAlignment = xlCenter\n        .WrapText = False\n        .Orientation = 0\n        .AddIndent = False\n        .IndentLevel = 0\n        .ShrinkToFit = False\n        .ReadingOrder = xlContext\n        .MergeCells = False\n    End With\n    With Selection.Interior\n        .Pattern = xlSolid\n        .PatternColorIndex = xlAutomatic\n        .Color = 65535\n        .TintAndShade = 0\n        .PatternTintAndShade = 0\n    End With\n\n    Range(\"A2\").Select\n    ActiveWindow.FreezePanes = True\n\n    ActiveWindow.DisplayGridlines = False\nEnd Sub<\/pre>\n\n\n\n<p>Analyzing this code:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112.png\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"517\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d\uae30\ub85c \uc0dd\uc131\ub41c \ucf54\ub4dc \ubd84\uc11d\" class=\"wp-image-11410\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112.png 979w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-300x158.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-768x406.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-48x25.png 48w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/a><figcaption>Code analysis generated by the macro recorder<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Even if you are not familiar with Excel Object Model or VBA syntax, you can create useful macros by using the VBA code created in this way. If you use the macro recorder well, VBA coding becomes easy.<\/p>\n\n\n\n<p>For reference, Excel is the only macro recorder among the Ms-Office suites.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.7._\ucf54\ub529\uc2dc_\uc9c0\ud0a4\uba74_\uc88b\uc744_\uae30\ubcf8_\uc6d0\uce59\"><span class=\"ez-toc-section\" id=\"47_%EC%BD%94%EB%94%A9%EC%8B%9C_%EC%A7%80%ED%82%A4%EB%A9%B4_%EC%A2%8B%EC%9D%84_%EA%B8%B0%EB%B3%B8_%EC%9B%90%EC%B9%99\"><\/span>4.7. Basic principles to follow when coding<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is recommended to keep the following basic principles when coding using Excel VBA.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Do not put the changed value inside, but receive input from the outside (UI).<\/li><li>Don&#039;t structure it as a Module\/Class from the beginning, focus only on the purpose of the implementation at first.<ul><li>Structuring takes additional time, which should not affect the original work schedule.<\/li><li>VBA is a means (tool), not an end. Be careful not to turn over.<\/li><\/ul><\/li><li>If it is used more than 3 times or if it is clear that it will be used continuously in the future, refactor and structure it into Module\/Class considering reusability. (Make -&gt; Copy -&gt; Refactoring)<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>In this article, we looked at how-tos that are good to know when coding Excel VBA. Next, we will look at examples of tools developed and used with Excel VBA. This will be the last post of the Excel VBA lecture.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt; Related article list &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-preface\/\">Start the Excel VBA course. (Lecture notice, feat. Why we recommend Excel VBA)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-1-overview\/\">Excel VBA Course(1): Overview of Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/\">Excel VBA Course (2): Excel VBA Basics<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-3-object-model\/\">Excel VBA Course (3): Excel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-4-handling-object-model\/\">Excel VBA Course (4): Working with Excel Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Excel VBA Course (5): Excel File Extension, VBE, Font Settings<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-6-variable\/\">Excel VBA Course (6): Excel VBA Language Basics - Variables<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-7-syntax\/\">Excel VBA Course (7): Excel VBA Language Basics - Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-8-datatype\/\">Excel VBA Course (8): Excel VBA Language Basics - Data Types, Data Structures<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/\">Excel VBA Courses (9): Excel VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-10-self-developed-tools\/\">Excel VBA Course (10): Tools developed and used with Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/\">Full Table of Contents for Excel VBA Courses<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>This article examines the Excel VBA How-To. Please refer to it when coding Excel VBA. This is a continuation of the previous article. Excel VBA Lecture (8): Basic Excel VBA Language - Data type, Data structure 4. Excel VBA How-To 4.1. How to configure UI (User Interface) Receive input values from the user in Excel VBA or...<\/p>","protected":false},"author":1,"featured_media":11398,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11393","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T10:52:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:42:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\" \/>\n\t<meta property=\"og:image:width\" content=\"392\" \/>\n\t<meta property=\"og:image:height\" content=\"319\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To\",\"datePublished\":\"2022-09-11T10:52:01+00:00\",\"dateModified\":\"2022-10-11T02:42:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/\"},\"wordCount\":244,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-100.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-100.png\",\"datePublished\":\"2022-09-11T10:52:01+00:00\",\"dateModified\":\"2022-10-11T02:42:51+00:00\",\"description\":\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-100.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-100.png\",\"width\":392,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-9-how-to\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA Tutorial (9): Excel VBA How-To - Productivity Skill","description":"This article explores Excel VBA How-Tos. You&#039;ll learn how to configure the UI, execute VBA code, utilize the Immediate Window and Object Browser tools, improve VBA performance, utilize the macro recorder, and learn basic principles to follow when coding.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/","og_locale":"en_US","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-lecture-9-how-to\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T10:52:01+00:00","article_modified_time":"2022-10-11T02:42:51+00:00","og_image":[{"width":392,"height":319,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To","datePublished":"2022-09-11T10:52:01+00:00","dateModified":"2022-10-11T02:42:51+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/"},"wordCount":244,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/","name":"Excel VBA Tutorial (9): Excel VBA How-To - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","datePublished":"2022-09-11T10:52:01+00:00","dateModified":"2022-10-11T02:42:51+00:00","description":"This article explores Excel VBA How-Tos. You&#039;ll learn how to configure the UI, execute VBA code, utilize the Immediate Window and Object Browser tools, improve VBA performance, utilize the macro recorder, and learn basic principles to follow when coding.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","width":392,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11393"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11398"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}