{"id":11423,"date":"2022-09-11T23:07:07","date_gmt":"2022-09-11T14:07:07","guid":{"rendered":"https:\/\/prodskill.com\/?p=11423"},"modified":"2022-09-12T17:17:22","modified_gmt":"2022-09-12T08:17:22","slug":"excel-vba-lecture-toc","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/","title":{"rendered":"Full Table of Contents for Excel VBA Courses"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"324\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png\" alt=\"\" class=\"wp-image-11441\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png 576w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize-300x169.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize-36x20.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize-48x27.png 48w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/figure>\n<\/div>\n\n\n<p>I&#039;m uploading a separate table of contents for the entire Excel VBA lecture I&#039;ve been writing. I put a link in the entire table of contents so that you can find this article as an index.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-preface\/\">Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) (prodskill.com)<\/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-toc\/#1_%EC%97%91%EC%85%80_VBA_%EA%B0%9C%EC%9A%94\" >1. Excel VBA Overview<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/#2_%EC%97%91%EC%85%80_VBA_%EA%B8%B0%EC%B4%88\" >2. Excel VBA Basics<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/#3_%EC%97%91%EC%85%80_VBA_%EC%96%B8%EC%96%B4_%EA%B8%B0%EB%B3%B8\" >3. Excel VBA language basics<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/#4_%EC%97%91%EC%85%80_VBA_How-To\" >4. Excel VBA How-To<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/#5_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EA%B0%9C%EB%B0%9C%ED%95%98%EC%97%AC_%EC%82%AC%EC%9A%A9%EC%A4%91%EC%9D%B8_%EB%8F%84%EA%B5%AC\" >5. Tools developed with Excel VBA<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_%EC%97%91%EC%85%80_VBA_%EA%B0%9C%EC%9A%94\"><\/span><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#1_%EC%97%91%EC%85%80_VBA_%EA%B0%9C%EC%9A%94\">1. Excel VBA Overview<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#11_VBA_Macro_%EA%B0%9C%EB%85%90\">1.1. VBA, Macro concept<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#12_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%A0%91%EA%B7%BC%ED%95%98%EB%8A%94%EB%8D%B0_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%ED%97%98_%EC%A7%80%EC%8B%9D_%EB%A7%88%EC%9D%8C%EA%B0%80%EC%A7%90\">1.2. Experience, knowledge, and mindset required to approach Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#13_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EB%AC%B4%EC%97%87%EC%9D%84_%ED%95%A0_%EC%88%98_%EC%9E%88%EB%82%98\">1.3. What can you do with Excel VBA?<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#14_%EC%97%91%EC%85%80_VBA_%ED%95%99%EC%8A%B5%EC%9D%98_%EB%8B%A8%EA%B3%84%EC%A0%81_%EC%A0%91%EA%B7%BC\">1.4. A step-by-step approach to learning Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#15_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%96%B4%EB%A0%A4%EC%9B%8C_%ED%95%98%EB%8A%94_%EC%9A%94%EC%86%8C%EC%99%80_%ED%95%B4%EA%B2%B0%EB%B0%A9%EB%B2%95\">1.5. Factors that make Excel VBA difficult and how to solve it<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#16_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%A0_%EB%95%8C%EC%99%80_%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80_%EB%A7%90%EC%95%84%EC%95%BC_%ED%95%A0_%EB%95%8C\">1.6. Do&#039;s and Don&#039;ts of using Excel VBA<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#161_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%A0_%EB%95%8C\">1.6.1. When using Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-1\/#161_%EC%97%91%EC%85%80_VBA%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80_%EB%A7%90%EC%95%84%EC%95%BC_%ED%95%A0_%EB%95%8C\">1.6.1. When not to use Excel VBA<\/a><\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%EC%97%91%EC%85%80_VBA_%EA%B8%B0%EC%B4%88\"><\/span><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-2\/#2_%EC%97%91%EC%85%80_VBA_%EA%B8%B0%EC%B4%88\">2. Excel VBA Basics<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-2\/#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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-2\/#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><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-2\/#221_Hello_World_%EC%B6%9C%EB%A0%A5%ED%95%98%EA%B8%B0\">2.2.1. \u201cHello, World!\u201d output<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-2\/#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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-2\/#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><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#23_%EC%97%91%EC%85%80_Object_Model\">2.3. Excel Object Model<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#231_Application\">2.3.1. Application<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#232_Workbooks\">2.3.2. Workbooks<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#233_Workbook\">2.3.3. Workbook<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#234_Worksheets\">2.3.4. Worksheets<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#235_Worksheet\">2.3.5. Worksheet<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-3\/#236_Range\">2.3.6. Range<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-4-handling-object-model\/#24_%EA%B0%84%EB%8B%A8%ED%95%9C_%EC%BD%94%EB%93%9C%EB%A1%9C_%EC%97%91%EC%85%80_Object_Model_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\">2.4. Understanding the Excel Object Model with simple code<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-4-handling-object-model\/#241_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EA%B8%B0%EB%B3%B8%ED%98%95\">2.4.1. object access primitives<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-4-handling-object-model\/#242_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%EB%8B%A8%EC%88%9C%ED%98%95\">2.4.2. simple object access<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-4-handling-object-model\/#243_%EA%B0%9D%EC%B2%B4_%EC%A0%91%EA%B7%BC_%ED%99%9C%EC%9A%A9_%EC%98%88%EC%A0%9C\">2.4.3. Object Access &amp; Utilization Examples<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-4-handling-object-model\/#25_%EC%97%91%EC%85%80_Object_Model_%EC%83%81%EC%84%B8\">2.5. Excel Object Model Details<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#26_%EC%97%91%EC%85%80_%ED%8C%8C%EC%9D%BC_%ED%99%95%EC%9E%A5%EC%9E%90\">2.6. Excel File Extension<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#27_VBEVisual_Basic_for_Application_Editor\">2.7. Visual Basic for Application Editor (VBE)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#271_VBE_%EC%A0%84%ED%99%98%ED%95%98%EA%B8%B0_%EB%8B%A8%EC%B6%95%ED%82%A4%EB%A1%9C_%EC%8B%A4%ED%96%89\">2.7.1. Execute with shortcut to switch VBE<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#272_VBE_%EC%A0%84%ED%99%98%ED%95%98%EA%B8%B0_%EB%A6%AC%EB%B3%B8%EB%B0%94_%EB%B2%84%ED%8A%BC%EC%9C%BC%EB%A1%9C_%EC%8B%A4%ED%96%89\">2.7.2. Toggle VBE Execute with ribbon bar button<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#273_VBE_%EC%84%A4%EC%A0%95\">2.7.3. VBE settings<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#274_VBE_%ED%99%94%EB%A9%B4_%EA%B5%AC%EC%84%B1\">2.7.4. VBE Screen Composition<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-5-excel-file-extension-vbe-font\/#275_%EA%B0%80%EB%8F%85%EC%84%B1_%EC%A2%8B%EC%9D%80_%EA%B3%A0%EC%A0%95%ED%8F%AD_%EA%B8%80%EA%BC%B4_%EC%B6%94%EC%B2%9C\">2.7.5. Recommended monospaced fonts that are easy to read<\/a><\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_%EC%97%91%EC%85%80_VBA_%EC%96%B8%EC%96%B4_%EA%B8%B0%EB%B3%B8\"><\/span><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-6-variable\/#3_%EC%97%91%EC%85%80_VBA_%EC%96%B8%EC%96%B4_%EA%B8%B0%EB%B3%B8\">3. Excel VBA language basics<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-6-variable\/#31_%EB%B3%80%EC%88%98\">3.1. variable<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-6-variable\/#311_%EB%B3%80%EC%88%98_%EC%84%A0%EC%96%B8\">3.1.1. variable declaration<\/a><\/li><\/ul><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-6-variable\/#312_%EB%B3%80%EC%88%98_Early_binding_Late_binding\">3.1.2. Variables Early binding, Late binding<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#32_%EC%96%B8%EC%96%B4_%EB%AC%B8%EB%B2%95Syntax\">3.2. Language Syntax<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#321_%EC%A1%B0%EA%B1%B4%EB%AC%B8IF\">3.2.1. conditional statement (IF)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Single_line_IF_%EB%AC%B8%EB%B2%95\">Single line IF syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Single_line_IF_sample_code\">Single line IF sample code<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Multiple_line_IF_%EB%AC%B8%EB%B2%95\">Multiple line IF syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Multiple_line_IF_sample_code\">Multiple line IF sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#322_%EC%A1%B0%EA%B1%B4%ED%95%A8%EC%88%98IIF\">3.2.2. Condition function (IIF)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#IIF_%EB%AC%B8%EB%B2%95\">IIF grammar<\/a><\/li><\/ul><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#IIF_sample_code\">IIF sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#323_%EC%A1%B0%EA%B1%B4%EB%AC%B8Select_Case\">3.2.3. Conditional statement (Select Case)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Select_Case_%EC%A1%B0%EA%B1%B4%EB%AC%B8_%EB%AC%B8%EB%B2%95\">Select Case Conditional Syntax<\/a><\/li><\/ul><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Select_Case_%EC%A1%B0%EA%B1%B4%EB%AC%B8_sample_code\">Select Case conditional sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#324_%EB%B0%98%EB%B3%B5%EB%AC%B8For\">3.2.4. Repeat statement (For)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#For_Next_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\">For Next Loop Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#For_Next_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\">For Next loop sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#325_%EB%B0%98%EB%B3%B5%EB%AC%B8For_Each\">3.2.5. Loop (For Each)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#For_Each_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\">For Each Loop Syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#For_Each_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\">For Each loop sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#326_%EB%B0%98%EB%B3%B5%EB%AC%B8While\">3.2.6. loop (While)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#While_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\">while loop syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#While_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\">While loop sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#327_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EC%A0%9C%EC%96%B4Exit_Continue\">3.2.7. Loop control (Exit, Continue)<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#If_block_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\">How to use If block<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Goto_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\">How to use Goto<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#328_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8Procedure\">3.2.8. Procedure<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Sub_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_%EB%AC%B8%EB%B2%95\">Sub procedure syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Sub_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_sample_code\">Sub procedure sample code<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Function_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_%EB%AC%B8%EB%B2%95\">Function procedure syntax<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#Function_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_sample_code\">Function procedure sample code<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#329_%EC%98%A4%EB%A5%98_%EC%B2%98%EB%A6%AC\">3.2.9. error handling<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#3210_VBVisual_Basic_%EC%84%A4%EB%AA%85%EC%84%9C_%EB%8F%84%EC%9B%80%EB%A7%90CHM\">3.2.10. Visual Basic (VB) Documentation Help (CHM)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-7-syntax\/#3211_Office_2013_VBA_%EC%84%A4%EB%AA%85%EC%84%9CCHM_%EC%98%81%EC%96%B4\">3.2.11. Office 2013 VBA Documentation (CHM, English)<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#33_%EC%9E%90%EB%A3%8C%ED%98%95\">3.3. data type<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#331_%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95\">3.3.1. basic data type<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#%EA%B8%B0%EB%B3%B8_%EC%9E%90%EB%A3%8C%ED%98%95_%EB%AA%A9%EB%A1%9D\">List of basic data types<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#Variant_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\">Variant data type<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#User-defined%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%98%95%EC%8B%9D\">User-defined data type<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#332_%EC%9E%90%EB%A3%8C%EA%B5%AC%EC%A1%B0\">3.3.2. data structure<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#Array\">Array<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#Collection\">Collection<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-8-datatype\/#Dictionary\">Dictionary<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_%EC%97%91%EC%85%80_VBA_How-To\"><\/span><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-9-how-to\/#4_%EC%97%91%EC%85%80_VBA_How-To\">4. Excel VBA How-To<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><\/ul><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><\/ul><ul><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/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>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EA%B0%9C%EB%B0%9C%ED%95%98%EC%97%AC_%EC%82%AC%EC%9A%A9%EC%A4%91%EC%9D%B8_%EB%8F%84%EA%B5%AC\"><\/span><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#5_%EC%97%91%EC%85%80_VBA%EB%A1%9C_%EA%B0%9C%EB%B0%9C%ED%95%98%EC%97%AC_%EC%82%AC%EC%9A%A9%EC%A4%91%EC%9D%B8_%EB%8F%84%EA%B5%AC\">5. Tools developed with Excel VBA<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#51_%EB%84%A4%EC%9D%B4%EB%B2%84_%EA%B5%AD%EC%96%B4%EC%82%AC%EC%A0%84_%EC%98%81%EC%96%B4%EC%82%AC%EC%A0%84_%EA%B2%80%EC%83%89_%EB%8F%84%EA%B5%AC\">5.1. Naver Korean Dictionary, English Dictionary Search Tool<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#52_1%EC%B0%A8%EC%9B%90_Bin_Packing_%EC%95%8C%EA%B3%A0%EB%A6%AC%EC%A6%98%EC%9D%84_%ED%99%9C%EC%9A%A9%ED%95%9C_%EC%9E%91%EC%97%85_%EB%B0%B0%EB%B6%84_%EC%B5%9C%EC%A0%81%ED%99%94_%EB%8F%84%EA%B5%AC\">5.2. Work allocation optimization tool using one-dimensional bin packing algorithm<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#53_%EB%8D%B0%EC%9D%B4%ED%84%B0_%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80_%EB%8F%84%EA%B5%AC\">5.3. Data standard check tool<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#54_DA_Macro_%EB%8F%84%EA%B5%AC\">5.4. DA# Macro Tool<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#55_PowerDesigner_Macro_%EB%8F%84%EA%B5%AC\">5.5. PowerDesigner Macro tool<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#56_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EC%A0%84%ED%99%98%EC%9D%B4%ED%96%89_Migration_%EB%8F%84%EA%B5%AC\">5.6. Data Migration (Migration) Tools<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#56_Excel_Data_Downloader\"><\/a><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#57_Excel_Data_Downloader\">5.7. Excel Data Downloader<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#56_Excel_Data_Downloader\"><\/a><a href=\"https:\/\/prodskill.com\/en\/ko_kr\/excel-vba-lecture-10-self-developed-tools\/#58_Excel_Data_Uploader\">5.8. Excel Data Uploader<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>I&#039;m uploading a separate table of contents for the entire Excel VBA lecture I&#039;ve been writing. I put a link in the entire table of contents so that you can find this article as an index. Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) (prodskill.com) 1. Excel VBA Overview 1.1. VBA, Macro concept...<\/p>","protected":false},"author":1,"featured_media":11441,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11423","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 \uc804\uccb4 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uadf8\ub3d9\uc548 \uc791\uc131\ud588\ub358 \uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28\ub97c \ubcc4\ub3c4\ub85c \uc815\ub9ac\ud558\uc5ec \uc62c\ub9b0\ub2e4. \uc774 \uae00\uc744 index\ub85c \uac15\uc88c\uae00\uc744 \ucc3e\uc544\uac08 \uc218 \uc788\ub3c4\ub85d \uc804\uccb4 \ubaa9\ucc28\uc5d0 \ub9c1\ud06c\ub97c \ub2ec\uc544 \ub450\uc5c8\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-toc\/\" \/>\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 \uc804\uccb4 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uadf8\ub3d9\uc548 \uc791\uc131\ud588\ub358 \uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28\ub97c \ubcc4\ub3c4\ub85c \uc815\ub9ac\ud558\uc5ec \uc62c\ub9b0\ub2e4. \uc774 \uae00\uc744 index\ub85c \uac15\uc88c\uae00\uc744 \ucc3e\uc544\uac08 \uc218 \uc788\ub3c4\ub85d \uc804\uccb4 \ubaa9\ucc28\uc5d0 \ub9c1\ud06c\ub97c \ub2ec\uc544 \ub450\uc5c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T14:07:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-12T08:17:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png\" \/>\n\t<meta property=\"og:image:width\" content=\"576\" \/>\n\t<meta property=\"og:image:height\" content=\"324\" \/>\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=\"3 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-toc\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28\",\"datePublished\":\"2022-09-11T14:07:07+00:00\",\"dateModified\":\"2022-09-12T08:17:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/\"},\"wordCount\":184,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/TOC_Black-and-White-City-Blog-Banner_resize.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-toc\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/TOC_Black-and-White-City-Blog-Banner_resize.png\",\"datePublished\":\"2022-09-11T14:07:07+00:00\",\"dateModified\":\"2022-09-12T08:17:22+00:00\",\"description\":\"\uadf8\ub3d9\uc548 \uc791\uc131\ud588\ub358 \uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28\ub97c \ubcc4\ub3c4\ub85c \uc815\ub9ac\ud558\uc5ec \uc62c\ub9b0\ub2e4. \uc774 \uae00\uc744 index\ub85c \uac15\uc88c\uae00\uc744 \ucc3e\uc544\uac08 \uc218 \uc788\ub3c4\ub85d \uc804\uccb4 \ubaa9\ucc28\uc5d0 \ub9c1\ud06c\ub97c \ub2ec\uc544 \ub450\uc5c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/TOC_Black-and-White-City-Blog-Banner_resize.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/TOC_Black-and-White-City-Blog-Banner_resize.png\",\"width\":576,\"height\":324},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-lecture-toc\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28\"}]},{\"@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 Full Table of Contents - Productivity Skills","description":"I&#039;m uploading a separate table of contents for the entire Excel VBA lecture I&#039;ve been writing. I put a link in the entire table of contents so that you can find this article as an index.","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-toc\/","og_locale":"en_US","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uadf8\ub3d9\uc548 \uc791\uc131\ud588\ub358 \uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28\ub97c \ubcc4\ub3c4\ub85c \uc815\ub9ac\ud558\uc5ec \uc62c\ub9b0\ub2e4. \uc774 \uae00\uc744 index\ub85c \uac15\uc88c\uae00\uc744 \ucc3e\uc544\uac08 \uc218 \uc788\ub3c4\ub85d \uc804\uccb4 \ubaa9\ucc28\uc5d0 \ub9c1\ud06c\ub97c \ub2ec\uc544 \ub450\uc5c8\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-lecture-toc\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T14:07:07+00:00","article_modified_time":"2022-09-12T08:17:22+00:00","og_image":[{"width":576,"height":324,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28","datePublished":"2022-09-11T14:07:07+00:00","dateModified":"2022-09-12T08:17:22+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/"},"wordCount":184,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.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-toc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/","name":"Excel VBA Tutorial Full Table of Contents - Productivity Skills","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png","datePublished":"2022-09-11T14:07:07+00:00","dateModified":"2022-09-12T08:17:22+00:00","description":"I&#039;m uploading a separate table of contents for the entire Excel VBA lecture I&#039;ve been writing. I put a link in the entire table of contents so that you can find this article as an index.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-toc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/TOC_Black-and-White-City-Blog-Banner_resize.png","width":576,"height":324},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-toc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28"}]},{"@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\/11423","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=11423"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11423\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11441"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}