{"id":11318,"date":"2022-09-11T11:42:24","date_gmt":"2022-09-11T02:42:24","guid":{"rendered":"https:\/\/prodskill.com\/?p=11318"},"modified":"2022-10-11T11:38:57","modified_gmt":"2022-10-11T02:38:57","slug":"excel-vba-lecture-2-basic","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/","title":{"rendered":"Excel VBA Course (2): Excel VBA Basics"},"content":{"rendered":"<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-2-basic\/#2_%EC%97%91%EC%85%80_VBA_%EA%B8%B0%EC%B4%88\" >2. Excel VBA Basics<\/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-2-basic\/#21_%EA%B8%B0%EB%B3%B8_%ED%99%98%EA%B2%BD_%EC%84%A4%EC%A0%95\" >2.1. Basic Preferences<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/#22_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%98%88%EC%A0%9C_%EB%94%B0%EB%9D%BC%ED%95%98%EA%B8%B0\" >2.2. Follow simple example<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/#221_%E2%80%9CHello_World%E2%80%9D_%EC%B6%9C%EB%A0%A5%ED%95%98%EA%B8%B0\" >2.2.1. \u201cHello, World!\u201d output<\/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-2-basic\/#222_Cell%EC%97%90_%EA%B0%92_%EC%9E%85%EB%A0%A5%ED%95%98%EA%B8%B0\" >2.2.2. Entering values into cells<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/#223_%ED%8C%8C%EC%9D%BC_%EC%83%88%EB%A1%9C_%EB%A7%8C%EB%93%A4%EA%B8%B0\" >2.2.3. New file<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"2._\uc5d1\uc140_VBA_\uae30\ucd08\"><span class=\"ez-toc-section\" id=\"2_%EC%97%91%EC%85%80_VBA_%EA%B8%B0%EC%B4%88\"><\/span>2. Excel VBA Basics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uae30\ubcf8_\ud658\uacbd_\uc124\uc815\"><span class=\"ez-toc-section\" id=\"21_%EA%B8%B0%EB%B3%B8_%ED%99%98%EA%B2%BD_%EC%84%A4%EC%A0%95\"><\/span>2.1. Basic Preferences<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To use VBA-related functions, first set the Developer tab to be visible on the Excel ribbon menu. Depending on the Excel version, the displayed screen is slightly different, but the method is almost the same.<\/p>\n\n\n\n<p>Run Excel and go through the following steps to set it up.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>File &gt; Options &gt; Customize Ribbon &gt; Check \u201cDevelopment Tools\u201d &gt; OK &gt; Check Show \u201cDevelopment Tools\u201d in Ribbon<\/p><\/blockquote>\n\n\n\n<p>\u25bc How to set the developer tools to be visible in Excel 2007, 2010<\/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-58.png\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"455\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58.png\" alt=\"Excel 2007, 2010\uc5d0\uc11c \uac1c\ubc1c\ub3c4\uad6c \ubcf4\uc774\uac8c \uc124\uc815\ud558\ub294 \ubc29\ubc95\" class=\"wp-image-11319\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58.png 708w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58-300x193.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-58-48x31.png 48w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/a><figcaption>How to set developer tools visible in Excel 2007, 2010<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u25bc How to set the developer tools to be visible in Excel 2013 or later<\/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-59.png\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"466\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png\" alt=\"Excel 2013 \uc774\ud6c4 \ubc84\uc804\uc5d0\uc11c \uac1c\ubc1c\ub3c4\uad6c \ubcf4\uc774\uac8c \uc124\uc815\ud558\ub294 \ubc29\ubc95\" class=\"wp-image-11320\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png 742w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59-300x188.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59-36x23.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59-48x30.png 48w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/a><figcaption>How to set development tools to be visible in Excel 2013 or later<\/figcaption><\/figure>\n<\/div>\n\n\n<p>This completes the basic environment setup.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._\uac04\ub2e8\ud55c_\uc608\uc81c_\ub530\ub77c\ud558\uae30\"><span class=\"ez-toc-section\" id=\"22_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%98%88%EC%A0%9C_%EB%94%B0%EB%9D%BC%ED%95%98%EA%B8%B0\"><\/span>2.2. Follow simple example<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Before getting into the theory, let&#039;s follow a simple example using Excel VBA.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.2.1._&quot;Hello,_World!&quot;_\ucd9c\ub825\ud558\uae30\"><span class=\"ez-toc-section\" id=\"221_%E2%80%9CHello_World%E2%80%9D_%EC%B6%9C%EB%A0%A5%ED%95%98%EA%B8%B0\"><\/span>2.2.1. \u201cHello, World!\u201d output<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Let&#039;s print \u201cHello, World!\u201d, the first example (\ud83d\ude09) of any development language.<\/p>\n\n\n\n<p>Click the \u201cVisual Basic\u201d button in the developer tool ribbon menu or use the shortcut key&nbsp;<strong>Alt<\/strong>&nbsp;+&nbsp;<strong>F11<\/strong>&nbsp;If you press , VBE (Visual Basic Editor) 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-60.png\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"430\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60.png\" alt=\"VBE(Visual Basic Editor) \ud654\uba74\" class=\"wp-image-11321\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60.png 690w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60-300x187.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-60-48x30.png 48w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption>Visual Basic Editor (VBE) screen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Here, click \u201cView menu &gt; Immediate Window\u201d.<\/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-61.png\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"430\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d \uba54\ub274 \ud074\ub9ad\" class=\"wp-image-11322\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61.png 690w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61-300x187.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-61-48x30.png 48w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption>Click on the Immediate window menu<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The Immediate window is displayed 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-62.png\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"430\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d \ud45c\uc2dc\" class=\"wp-image-11323\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62.png 690w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62-300x187.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-62-48x30.png 48w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption>Show the Immediate Window<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Copy and paste the following code into the Immediate window and press Enter.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">MsgBox \"Hello, World!\"<\/pre>\n\n\n\n<p>Hello, World!\u201d A message window appears. Close it by clicking the \u201cOK\u201d button.<\/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-63.png\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"430\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63.png\" alt=\"&quot;Hello, World!&quot; \uba54\uc2dc\uc9c0 \ucd9c\ub825\" class=\"wp-image-11324\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63.png 690w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63-300x187.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-63-48x30.png 48w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/a><figcaption>\u201cHello, World!\u201d message output<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"2.2.2._Cell\uc5d0_\uac12_\uc785\ub825\ud558\uae30\"><span class=\"ez-toc-section\" id=\"222_Cell%EC%97%90_%EA%B0%92_%EC%9E%85%EB%A0%A5%ED%95%98%EA%B8%B0\"><\/span>2.2.2. Entering values into cells<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>This time, let&#039;s look at the code to enter a value in a specific cell of the sheet. Copy and paste the following code into the Immediate window and press Enter.<\/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=\"\">Range(\"B2\") = \"\uc9c1\uc811 \uc2e4\ud589 \ucc3d\uc5d0\uc11c \uc785\ub825\"<\/pre>\n\n\n\n<p>You can confirm that the specified value is entered in the \u201cB2\u201d cell 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-64.png\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"429\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d\uc5d0\uc11c cell\uc5d0 \uac12 \uc785\ub825\" class=\"wp-image-11325\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64.png 697w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64-300x185.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-64-48x30.png 48w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/a><figcaption>Enter values into cells in the Immediate window<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"2.2.3._\ud30c\uc77c_\uc0c8\ub85c_\ub9cc\ub4e4\uae30\"><span class=\"ez-toc-section\" id=\"223_%ED%8C%8C%EC%9D%BC_%EC%83%88%EB%A1%9C_%EB%A7%8C%EB%93%A4%EA%B8%B0\"><\/span>2.2.3. New file<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Let&#039;s create a new file this time.<\/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=\"\">Workbooks.Add<\/pre>\n\n\n\n<p>A new \u201cWorkbook 3\u201d is created. The number is the number of new files incremented by 1 after Excel is launched. The number may be different for each execution environment.<\/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-65.png\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"431\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65.png\" alt=\"\ud30c\uc77c \uc0c8\ub85c \ub9cc\ub4e4\uae30 \uacb0\uacfc\" class=\"wp-image-11326\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65.png 695w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65-300x186.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-65-48x30.png 48w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><figcaption>File New Results<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>I&#039;ve followed environment settings and simple examples so far. If you are new to Excel VBA, please give it a try.<\/p>\n\n\n\n<p>Next, we will take a look at the Excel Object Model.<\/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>2. Excel VBA Basics 2.1. Basic Environment Settings To use VBA-related functions, first set the Developer tab to be visible on the Excel ribbon menu. Depending on the Excel version, the displayed screen is slightly different, but the method is almost the same. Run Excel and proceed with the following steps to set it up. File &gt; Options &gt;...<\/p>","protected":false},"author":1,"featured_media":11320,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11318","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.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ucd08\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \uae30\ubcf8 \ud658\uacbd\uc124\uc815\uacfc &quot;Hello, World&quot;, Cell\uac12 \uc785\ub825\ud558\uae30, \ud30c\uc77c \uc0c8\ub85c \ub9cc\ub4e4\uae30 \ub4f1\uc758 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \uac04\ub2e8\ud558\uace0 \uc27d\uac8c \ub530\ub77c\ud574 \ubcfc \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-2-basic\/\" \/>\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(2): \uc5d1\uc140 VBA \uae30\ucd08 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ucd08\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \uae30\ubcf8 \ud658\uacbd\uc124\uc815\uacfc &quot;Hello, World&quot;, Cell\uac12 \uc785\ub825\ud558\uae30, \ud30c\uc77c \uc0c8\ub85c \ub9cc\ub4e4\uae30 \ub4f1\uc758 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \uac04\ub2e8\ud558\uace0 \uc27d\uac8c \ub530\ub77c\ud574 \ubcfc \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T02:42:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:38:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"466\" \/>\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=\"4 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-2-basic\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08\",\"datePublished\":\"2022-09-11T02:42:24+00:00\",\"dateModified\":\"2022-10-11T02:38:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/\"},\"wordCount\":93,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-59.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-2-basic\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-59.png\",\"datePublished\":\"2022-09-11T02:42:24+00:00\",\"dateModified\":\"2022-10-11T02:38:57+00:00\",\"description\":\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ucd08\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \uae30\ubcf8 \ud658\uacbd\uc124\uc815\uacfc \\\"Hello, World\\\", Cell\uac12 \uc785\ub825\ud558\uae30, \ud30c\uc77c \uc0c8\ub85c \ub9cc\ub4e4\uae30 \ub4f1\uc758 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \uac04\ub2e8\ud558\uace0 \uc27d\uac8c \ub530\ub77c\ud574 \ubcfc \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-59.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-59.png\",\"width\":742,\"height\":466},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-2-basic\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08\"}]},{\"@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 (2): Excel VBA Basics - Productivity Skills","description":"This article explores the fundamentals of Excel VBA. It provides simple, easy-to-follow examples, including basic environment settings, &quot;Hello, World,&quot; entering cell values, and creating a new file.","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-2-basic\/","og_locale":"en_US","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ucd08\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uc0b4\ud3b4\ubcf8\ub2e4. \uae30\ubcf8 \ud658\uacbd\uc124\uc815\uacfc \"Hello, World\", Cell\uac12 \uc785\ub825\ud558\uae30, \ud30c\uc77c \uc0c8\ub85c \ub9cc\ub4e4\uae30 \ub4f1\uc758 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \uac04\ub2e8\ud558\uace0 \uc27d\uac8c \ub530\ub77c\ud574 \ubcfc \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-lecture-2-basic\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T02:42:24+00:00","article_modified_time":"2022-10-11T02:38:57+00:00","og_image":[{"width":742,"height":466,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08","datePublished":"2022-09-11T02:42:24+00:00","dateModified":"2022-10-11T02:38:57+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/"},"wordCount":93,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.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-2-basic\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/","name":"Excel VBA Tutorial (2): Excel VBA Basics - Productivity Skills","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png","datePublished":"2022-09-11T02:42:24+00:00","dateModified":"2022-10-11T02:38:57+00:00","description":"This article explores the fundamentals of Excel VBA. It provides simple, easy-to-follow examples, including basic environment settings, &quot;Hello, World,&quot; entering cell values, and creating a new file.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-59.png","width":742,"height":466},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08"}]},{"@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\/11318","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=11318"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11318\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11320"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}