{"id":11373,"date":"2022-09-11T17:17:38","date_gmt":"2022-09-11T08:17:38","guid":{"rendered":"https:\/\/prodskill.com\/?p=11373"},"modified":"2022-10-11T11:41:54","modified_gmt":"2022-10-11T02:41:54","slug":"excel-vba-lecture-7-syntax","status":"publish","type":"post","link":"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/","title":{"rendered":"Excel VBA\u6559\u7a0b\uff08\u4e03\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840\u2014\u2014\u8bed\u6cd5"},"content":{"rendered":"\n<p>\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA\uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubb38\ubc95(Syntax)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804&nbsp;\uae00\uc5d0\uc11c&nbsp;\uc774\uc5b4\uc9c0\ub294&nbsp;\ub0b4\uc6a9\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\">\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218<\/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;\ubaa9\ucc28&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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#32_%EC%96%B8%EC%96%B4_%EB%AC%B8%EB%B2%95Syntax\" >3.2. \uc5b8\uc5b4 \ubb38\ubc95(Syntax)<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#321_%EC%A1%B0%EA%B1%B4%EB%AC%B8IF\" >3.2.1. \uc870\uac74\ubb38(IF)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Single_line_IF_%EB%AC%B8%EB%B2%95\" >Single line IF \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Single_line_IF_sample_code\" >Single&nbsp;line&nbsp;IF&nbsp;sample code<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Multiple_line_IF_%EB%AC%B8%EB%B2%95\" >Multiple line IF \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Multiple_line_IF_sample_code\" >Multiple&nbsp;line&nbsp;IF sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#322_%EC%A1%B0%EA%B1%B4%ED%95%A8%EC%88%98IIF\" >3.2.2. \uc870\uac74\ud568\uc218(IIF)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#IIF_%EB%AC%B8%EB%B2%95\" >IIF&nbsp;\ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#IIF_sample_code\" >IIF sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#323_%EC%A1%B0%EA%B1%B4%EB%AC%B8Select_Case\" >3.2.3. \uc870\uac74\ubb38(Select Case)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Select_Case_%EC%A1%B0%EA%B1%B4%EB%AC%B8_%EB%AC%B8%EB%B2%95\" >Select Case \uc870\uac74\ubb38 \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Select_Case_%EC%A1%B0%EA%B1%B4%EB%AC%B8_sample_code\" >Select Case \uc870\uac74\ubb38 sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#324_%EB%B0%98%EB%B3%B5%EB%AC%B8For\" >3.2.4. \ubc18\ubcf5\ubb38(For)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#For_Next_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\" >For Next \ubc18\ubcf5\ubb38 \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#For_Next_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\" >For&nbsp;Next&nbsp;\ubc18\ubcf5\ubb38&nbsp;sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#325_%EB%B0%98%EB%B3%B5%EB%AC%B8For_Each\" >3.2.5. \ubc18\ubcf5\ubb38(For Each)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#For_Each_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\" >For Each \ubc18\ubcf5\ubb38 \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#For_Each_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\" >For Each \ubc18\ubcf5\ubb38 sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#326_%EB%B0%98%EB%B3%B5%EB%AC%B8While\" >3.2.6. \ubc18\ubcf5\ubb38(While)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#While_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\" >While \ubc18\ubcf5\ubb38 \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#While_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\" >While \ubc18\ubcf5\ubb38 sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/prodskill.com\/zh\/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. \ubc18\ubcf5\ubb38 \uc81c\uc5b4(Exit, Continue)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#If_block_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >If block \uc0ac\uc6a9 \ubc29\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Goto_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >Goto \uc0ac\uc6a9 \ubc29\ubc95<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#328_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8Procedure\" >3.2.8. \ud504\ub85c\uc2dc\uc838(Procedure)<\/a><ul class='ez-toc-list-level-5' ><li class='ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/prodskill.com\/zh\/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 \ud504\ub85c\uc2dc\uc838 \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Sub_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_sample_code\" >Sub \ud504\ub85c\uc2dc\uc838 sample code<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/prodskill.com\/zh\/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 \ud504\ub85c\uc2dc\uc838 \ubb38\ubc95<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#Function_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_sample_code\" >Function \ud504\ub85c\uc2dc\uc838 sample code<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/#329_%EC%98%A4%EB%A5%98_%EC%B2%98%EB%A6%AC\" >3.2.9. \uc624\ub958 \ucc98\ub9ac<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/prodskill.com\/zh\/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. VB(Visual Basic) \uc124\uba85\uc11c \ub3c4\uc6c0\ub9d0(CHM)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/prodskill.com\/zh\/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 \uc124\uba85\uc11c(CHM, \uc601\uc5b4)<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"3.2._\uc5b8\uc5b4_\ubb38\ubc95(Syntax)\"><span class=\"ez-toc-section\" id=\"32_%EC%96%B8%EC%96%B4_%EB%AC%B8%EB%B2%95Syntax\"><\/span>3.2. \uc5b8\uc5b4 \ubb38\ubc95(Syntax)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>VBA \uc5b8\uc5b4 \ubb38\ubc95\uc740 Visual Basic \ubb38\ubc95\uacfc \ub3d9\uc77c\ud558\ub2e4. \ucc98\uc74c\uc5d0\ub294 \ubaa8\ub4e0 \ubb38\ubc95\uc744 \ub2e4 \uc54c \ud544\uc694\uac00 \uc5c6\uace0, \uc5ec\uae30\uc5d0 \uc694\uc57d\ud55c \ubb38\ubc95\ub9cc \uc54c\uc544\ub3c4 \ucda9\ubd84\ud558\ub2e4. \uc804\uccb4 \ubb38\ubc95\uc740 \ud558\ub2e8\uc5d0 \ucca8\ubd80\ud55c Visual Basic CHM \ub3c4\uc6c0\ub9d0 \ud30c\uc77c\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p>VBA \uc5b8\uc5b4\uc5d0 \ub300\ud55c \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0(\uc601\uc5b4\ub85c\ub9cc \uc81c\uacf5\ub428)\uc740 \uc544\ub798 URL\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/overview\/language-reference\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/overview\/language-reference<\/a><\/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-90.png\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"746\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png\" alt=\"Language reference for Visual Basic for Applications (VBA)\" class=\"wp-image-11374\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png 847w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90-300x264.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90-768x676.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90-24x21.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90-36x32.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90-48x42.png 48w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/a><figcaption>Language reference for Visual Basic for Applications (VBA)<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.1._\uc870\uac74\ubb38(IF)\"><span class=\"ez-toc-section\" id=\"321_%EC%A1%B0%EA%B1%B4%EB%AC%B8IF\"><\/span>3.2.1. \uc870\uac74\ubb38(IF)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc2dd\uc758&nbsp;\uac12\uc5d0&nbsp;\ub530\ub77c&nbsp;\ubb38&nbsp;\uadf8\ub8f9\uc744&nbsp;\uc870\uac74\ubd80\ub85c&nbsp;\uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Single_line_IF_%EB%AC%B8%EB%B2%95\"><\/span>Single line IF \ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">If condition Then [statements] [Else elsestatements]<\/pre>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Single_line_IF_sample_code\"><\/span>Single&nbsp;line&nbsp;IF&nbsp;sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">If Digits = 1 Then MyString = \"One\" Else MyString = \"More than one\"<\/pre>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Multiple_line_IF_%EB%AC%B8%EB%B2%95\"><\/span>Multiple line IF \ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">If condition Then\n    \u200b\u200b\u200b\u200b[statements]\n[ElseIf condition -n Then\n    \u200b\u200b\u200b\u200b[elseif statements]...]\n[Else\n    \u200b\u200b\u200b\u200b[else statements]]\nEnd If<\/pre>\n\n\n\n<p>Visual Basic \ub3c4\uc6c0\ub9d0<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><em>condition<\/em><ul><li>\ud544\uc218\uc801\uc778 \uc694\uc18c. \ub2e4\uc74c\uacfc \uac19\uc740 \ub450 \uac00\uc9c0 \ud615\uc2dd \uc911 \ud558\ub098 \uc774\uc0c1\uc758 \uc2dd\uc785\ub2c8\ub2e4.<\/li><li><strong>True<\/strong>\ub098 <strong>False<\/strong>\ub85c \ud3c9\uac00\ub418\ub294 \uc218\uc2dd\uc774\ub098 \ubb38\uc790\uc2dd\uc73c\ub85c <em>condition<\/em>\uc774 <strong>Null<\/strong>\uc774\uba74 <strong>False<\/strong>\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/li><li><em><strong>TypeOf <\/strong>objectname <strong>Is<\/strong> objecttype<\/em> \ud615\ud0dc\ub85c \ub41c \uc2dd\uc785\ub2c8\ub2e4. <em>Objectname<\/em>\uc740 \uac1c\uccb4 \ucc38\uc870\uc774\uba70, <em>objecttype<\/em>\uc740 \uc720\ud6a8\ud55c \uac1c\uccb4 \ud615\uc2dd\uc785\ub2c8\ub2e4. <em>Objectname<\/em>\uc774 <em>objecttype<\/em>\uc5d0 \uc758\ud574 \uc9c0\uc815\ub41c \uac1c\uccb4 \ud615\uc2dd\uc774\uba74 \uc2dd\uc740 True\uc774\uba70, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 False\uc785\ub2c8\ub2e4.<\/li><\/ul><\/li><li><em>statements<\/em><ul><li>\ube14\ub85d \ud615\ud0dc\uc5d0\uc11c\ub294 \uc120\ud0dd\uc801\uc778 \uc694\uc18c\uc774\uace0,<strong>&nbsp;Else<\/strong>\uc808\uc774 \uc5c6\ub294 \ub2e8\uc77c \ud589 \ud615\ud0dc\uc5d0\uc11c\ub294 \ud544\uc218\uc801\uc778 \uc694\uc18c\uc785\ub2c8\ub2e4. \ub458 \uc774\uc0c1\uc758 \ubb38\uc740 \ucf5c\ub860\uc73c\ub85c \uad6c\ubd84\ud558\uba70&nbsp;<em>condition<\/em>\uc774&nbsp;<strong>True<\/strong>\uc77c \uacbd\uc6b0 \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/li><\/ul><\/li><li><em>condition -n<\/em><ul><li>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<em>condition<\/em>\uacfc\ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/li><\/ul><\/li><li><em>elseif statements<\/em><ul><li>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc5f0\uad00\ub41c&nbsp;<em>condition-n<\/em>\uc774&nbsp;<strong>True<\/strong>\uc77c \uacbd\uc6b0 \uc2e4\ud589\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc785\ub2c8\ub2e4.<\/li><\/ul><\/li><li><em>else statements<\/em><ul><li>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc774\uc804\uc758<em>&nbsp;condition<\/em>\uc774\ub098&nbsp;<em>condition-n<\/em>\uc2dd\uc774&nbsp;<strong>True<\/strong>\uac00 \uc544\ub2d0 \uacbd\uc6b0 \uc2e4\ud589\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc785\ub2c8\ub2e4.<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/ifthenelse-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/ifthenelse-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Multiple_line_IF_sample_code\"><\/span>Multiple&nbsp;line&nbsp;IF sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Dim Number, Digits, MyString\nNumber = 53    ' \ubcc0\uc218\ub97c \ucd08\uae30\ud654\ud569\ub2c8\ub2e4.\nIf Number &lt; 10 Then\n    Digits = 1\nElseIf Number &lt; 100 Then '\uc870\uac74\uc774 True\ub85c \ud3c9\uac00\ub418\uba74 \ub2e4\uc74c \ubb38\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.\n    Digits = 2\nElse ' \uc870\uac74\uc774 False\ub85c \ud3c9\uac00\ub418\uba74 \ub2e4\uc74c \ubb38\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.\n    Digits = 3\nEnd If<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.2._\uc870\uac74\ud568\uc218(IIF)\"><span class=\"ez-toc-section\" id=\"322_%EC%A1%B0%EA%B1%B4%ED%95%A8%EC%88%98IIF\"><\/span>3.2.2. \uc870\uac74\ud568\uc218(IIF)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc2dd\uc744 \ud3c9\uac00\ud55c \uacb0\uacfc\uc5d0 \ub530\ub77c \ub450 \uac1c\uc758 \uac12 \uc911\uc5d0\uc11c \ud558\ub098\ub97c \ubc18\ud658\ud55c\ub2e4.<\/p>\n\n\n\n<p>IIF\ub294 \ud568\uc218(function)\uc774\uace0, If ~ Else ~ End If \uad6c\ubb38\uc744 \uac04\ub7b5\ud558\uac8c \ud45c\ud604\ud560 \ub54c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"IIF_%EB%AC%B8%EB%B2%95\"><\/span>IIF&nbsp;\ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">IIf(expr, true part, false part)<\/pre>\n\n\n\n<p>Visual&nbsp;Basic&nbsp;\ub3c4\uc6c0\ub9d0<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131\uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><strong><em>expr<\/em><\/strong><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \ud3c9\uac00\ud558\uace0\uc790 \ud558\ub294 \uc2dd<\/td><\/tr><tr><td><strong><em>true part<\/em><\/strong><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.&nbsp;<strong><em>expr<\/em><\/strong>\uc774&nbsp;<strong>True<\/strong>\uc778 \uacbd\uc6b0 \ubc18\ud658\ud558\ub294 \uac12\uc774\ub098 \uc2dd\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong><em>false part<\/em><\/strong><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.<strong><em>&nbsp;expr<\/em><\/strong>\uc774&nbsp;<strong>False<\/strong>\uc778 \uacbd\uc6b0 \ubc18\ud658\ud558\ub294 \uac12\uc774\ub098 \uc2dd\uc785\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/iif-function\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/iif-function<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"IIF_sample_code\"><\/span>IIF sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Function CheckIt (TestMe As Integer)\n    CheckIt = IIf(TestMe > 1000, \"Large\", \"Small\")\nEnd Function<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.3._\uc870\uac74\ubb38(Select_Case)\"><span class=\"ez-toc-section\" id=\"323_%EC%A1%B0%EA%B1%B4%EB%AC%B8Select_Case\"><\/span>3.2.3. \uc870\uac74\ubb38(Select Case)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc2dd\uc758 \uac12\uc5d0 \ub530\ub77c \uba87 \uac1c \uadf8\ub8f9\uc758 \ubb38 \uc911\uc758 \ud558\ub098\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Select_Case_%EC%A1%B0%EA%B1%B4%EB%AC%B8_%EB%AC%B8%EB%B2%95\"><\/span>Select Case \uc870\uac74\ubb38 \ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Select Case test expression\n    [Case expressionlist-n\n            [statements-n]] ...\n    [Case Else\n            [else statements]]\nEnd Select<\/pre>\n\n\n\n<p>Visual&nbsp;Basic&nbsp;\ub3c4\uc6c0\ub9d0<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131\uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><em>test expression<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \ubaa8\ub4e0&nbsp;\uc218\uc2dd\uc774\ub098&nbsp;\ubb38\uc790\uc2dd\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>expression list-n<\/em><\/td><td><strong>Case&nbsp;<\/strong>\ubb38\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ud544\uc218\uc801\uc778 \uc694\uc18c\uc785\ub2c8\ub2e4.&nbsp;<em>expression<\/em>,<em>&nbsp;expression<\/em>&nbsp;<strong>To<\/strong>&nbsp;<em>expression,<\/em>&nbsp;<strong>Is<\/strong>&nbsp;<em>comparisonoperator expression<\/em>\uacfc \uac19\uc740 \ud615\uc2dd\ub4e4 \uc911 \ud558\ub098 \uc774\uc0c1\uc758 \uad6c\ubd84\ub41c \ubaa9\ub85d\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.&nbsp;<strong>To<\/strong>&nbsp;\ud0a4\uc6cc\ub4dc\ub294 \uac12\uc758 \ubc94\uc704\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.&nbsp;<strong>To<\/strong>&nbsp;\ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub354 \uc791\uc740 \uac12\uc774&nbsp;<strong>To<\/strong>\ubb38 \uc55e\uc5d0 \uc640\uc57c \ud569\ub2c8\ub2e4. \uac12\uc758 \ubc94\uc704\ub97c \uc9c0\uc815\ud558\ub824\uba74&nbsp;\ube44\uad50 \uc5f0\uc0b0\uc790(<strong>Is<\/strong>&nbsp;\ubb38\uacfc&nbsp;<strong>Like<\/strong>\ubb38\uc740 \uc81c\uc678)\uc640 \ud568\uaed8&nbsp;<strong>Is<\/strong>&nbsp;\ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.&nbsp;<strong>Is<\/strong>&nbsp;\ud0a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc9c0 \uc54a\uc73c\uba74 \uc790\ub3d9\uc73c\ub85c \uc0bd\uc785\ub429\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>statements-n<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<em>testexpression<\/em>\uc5d0 \ub300\uc751\ud558\ub294&nbsp;<em>expressionlist<\/em>\uac00 \uc788\ub294 \uacbd\uc6b0 \ud574\ub2f9\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>else statements<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.<em>&nbsp;testexpression<\/em>\uc5d0 \ub300\uc751\ud558\ub294&nbsp;<strong>Case<\/strong>\uc808\uc774 \uc5c6\ub294 \uacbd\uc6b0 \ud574\ub2f9\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/select-case-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/select-case-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Select_Case_%EC%A1%B0%EA%B1%B4%EB%AC%B8_sample_code\"><\/span>Select Case \uc870\uac74\ubb38 sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Function Bonus(performance, salary)\n    Select Case performance\n        Case 1\n            Bonus = salary * 0.1\n        Case 2, 3\n            Bonus = salary * 0.09\n        Case 4 To 6\n            Bonus = salary * 0.07\n        Case Is > 8\n            Bonus = 100\n        Case Else\n            Bonus = 0\n    End Select\nEnd Function<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.4._\ubc18\ubcf5\ubb38(For)\"><span class=\"ez-toc-section\" id=\"324_%EB%B0%98%EB%B3%B5%EB%AC%B8For\"><\/span>3.2.4. \ubc18\ubcf5\ubb38(For)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ubb38\uc758 \uadf8\ub8f9\uc744 \uc9c0\uc815\ud55c \ud69f\uc218\ub9cc\ud07c \ubc18\ubcf5\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"For_Next_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\"><\/span>For Next \ubc18\ubcf5\ubb38 \ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">For counter= start To end [Step step]\n    [statements]\n    [Exit For]\n    [statements]\nNext [counter]<\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><em>\uad6c\uc131 \uc694\uc18c<\/em><\/td><td>\uc124\uba85<\/td><\/tr><tr><td><em>counter<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \ub8e8\ud504 \uce74\uc6b4\ud130\ub85c\uc11c \uc0ac\uc6a9\ub418\ub294 \uc22b\uc790&nbsp;\ubcc0\uc218. \uc774 \ubcc0\uc218\ub294&nbsp;Boolean&nbsp;\ub610\ub294&nbsp;\ubc30\uc5f4&nbsp;\uc694\uc18c\uac00 \ub420 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>start<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.<em>&nbsp;Counter<\/em>\uc758 \uc2dc\uc791\uac12<\/td><\/tr><tr><td><em>end<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.<em>&nbsp;Counter<\/em>\uc758 \ucd5c\uc885\uac12<\/td><\/tr><tr><td><em>step<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \ub8e8\ud504\ub97c \ud55c\ubc88 \uc218\ud589\ud560 \ub54c\ub9c8\ub2e4 \ubcc0\ud654\ud558\ub294&nbsp;<em>counter<\/em>\uc758 \uc591\uc785\ub2c8\ub2e4. \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74&nbsp;<em>step<\/em>\uc758 \uae30\ubcf8\uac12\uc740 1\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>statements<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>For<\/strong>\uc640&nbsp;<strong>Next&nbsp;<\/strong>\uc0ac\uc774\uc758 \uc788\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc774\uba70 \uc9c0\uc815\ud55c \ud69f\uc218\ub9cc\ud07c \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/fornext-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/fornext-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"For_Next_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\"><\/span>For&nbsp;Next&nbsp;\ubc18\ubcf5\ubb38&nbsp;sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Dim Words, Chars, MyString\nFor Words = 10 To 1 Step -1     ' 10\ubc88 \ubc18\ubcf5\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\n    For Chars = 0 To 9    ' 10\ubc88 \ubc18\ubcf5\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\n        MyString = MyString &amp; Chars    ' \uc22b\uc790\ub97c \ubb38\uc790\uc5f4\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4.\n    Next Chars    ' \uce74\uc6b4\ud130 \uc99d\uac00\n    MyString = MyString &amp; \" \"    ' \ube48 \uce78\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.\nNext Words<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.5._\ubc18\ubcf5\ubb38(For_Each)\"><span class=\"ez-toc-section\" id=\"325_%EB%B0%98%EB%B3%B5%EB%AC%B8For_Each\"><\/span>3.2.5. \ubc18\ubcf5\ubb38(For Each)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ubc30\uc5f4\uc774\ub098 \uceec\ub809\uc158\uc758 \uac01 \uc694\uc18c\ub4e4\uc5d0 \ub300\ud55c \ubb38\uc758 \uadf8\ub8f9\uc744 \ubc18\ubcf5\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"For_Each_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\"><\/span>For Each \ubc18\ubcf5\ubb38 \ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">For Each element In group\n    [statements]\n    [Exit For]\n    [statements]\nNext [element]<\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131 \uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><em>element<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \uceec\ub809\uc158\uc774\ub098 \ubc30\uc5f4\uc758 \uc694\uc18c\ub4e4\uc744 \ubc18\ubcf5 \uc2e4\ud589\ud558\ub294 \ub370 \uc0ac\uc6a9\ud558\ub294&nbsp;\ubcc0\uc218\uc785\ub2c8\ub2e4. \uceec\ub809\uc158\uc5d0\uc11c&nbsp;<em>element<\/em>\ub294 \uc624\uc9c1&nbsp;Variant&nbsp;\ubcc0\uc218\ub098 \uc77c\ubc18 \uac1c\uccb4 \ubcc0\uc218 \ub610\ub294 \ud2b9\uc815\ud55c \uac1c\uccb4 \ubcc0\uc218\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc30\uc5f4\uc5d0\uc11c&nbsp;<em>element<\/em>\ub294 \uc624\uc9c1&nbsp;<strong>Variant&nbsp;<\/strong>\ubcc0\uc218\ub9cc \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>group<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \uac01 \uac1c\uccb4 \uceec\ub809\uc158\uc774\ub098 \ubc30\uc5f4\uc758 \uc774\ub984(\uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd&nbsp;\ubc30\uc5f4\uc740 \uc81c\uc678)\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>statements<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.<em>&nbsp;group<\/em>\uc758 \uac01 \ud56d\ubaa9\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc785\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/for-eachnext-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/for-eachnext-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"For_Each_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\"><\/span>For Each \ubc18\ubcf5\ubb38 sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Dim Found, MyObject, MyCollection\nFound = False    ' \ubcc0\uc218\ub97c \ucd08\uae30\ud654\ud569\ub2c8\ub2e4.\nFor Each MyObject In MyCollection    ' \uac01\uac01\uc758 \uc694\uc18c\uc5d0 \ub300\ud574 \ubc18\ubcf5\ud569\ub2c8\ub2e4.\n    If MyObject.Text = \"Hello\" Then    ' Text\uac00 \"Hello\"\ub77c\uba74.\n        Found = True    ' Found\ubcc0\uc218\ub97c True\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.\n        Exit For    ' \ub8e8\ud504\ub97c \uc885\ub8cc\ud569\ub2c8\ub2e4.\n    End If\nNext<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.6._\ubc18\ubcf5\ubb38(While)\"><span class=\"ez-toc-section\" id=\"326_%EB%B0%98%EB%B3%B5%EB%AC%B8While\"><\/span>3.2.6. \ubc18\ubcf5\ubb38(While)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc8fc\uc5b4\uc9c4 \uc870\uac74\uc774 True\uc778 \ub3d9\uc548\uc740 \uc77c\ub828\uc758 \ubb38\uc744 \uacc4\uc18d \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"While_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EB%AC%B8%EB%B2%95\"><\/span>While \ubc18\ubcf5\ubb38 \ubb38\ubc95<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">While condition\n    \u200b\u200b\u200b\u200b[statements]\nWend<\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131 \uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><em>condition<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.&nbsp;<strong>True<\/strong>\ub098&nbsp;<strong>False<\/strong>\ub85c \ud3c9\uac00\ub418\ub294&nbsp;\uc218\uc2dd&nbsp;\ub610\ub294&nbsp;\ubb38\uc790\uc2dd. \ub9cc\uc57d&nbsp;<em>condition<\/em>\uc774&nbsp;Null\uc778 \uacbd\uc6b0&nbsp;<em>condition<\/em>\uc740&nbsp;<strong>False<\/strong>\ub85c \ucc98\ub9ac\ub429\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>statements<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc8fc\uc5b4\uc9c4 \uc870\uac74\uc774<strong>&nbsp;True<\/strong>\uc778 \ub3d9\uc548 \ud558\ub098 \uc774\uc0c1\uc758 \ubb38\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/whilewend-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/whilewend-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"While_%EB%B0%98%EB%B3%B5%EB%AC%B8_sample_code\"><\/span>While \ubc18\ubcf5\ubb38 sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">Dim Counter\nCounter = 0    ' \ubcc0\uc218\ub97c \ucd08\uae30\ud654\ud569\ub2c8\ub2e4.\nWhile Counter &lt; 20    ' \ubcc0\uc218 Counter \uac12\uc744 \uac80\uc0ac\ud569\ub2c8\ub2e4.\n    Counter = Counter + 1    ' \ubcc0\uc218 Counter \uac12\uc744 1\uc529 \uc99d\uac00\uc2dc\ud0b5\ub2c8\ub2e4.\nWend    ' \ubcc0\uc218 Counter\uc758 \uac12\uc774 19\ubcf4\ub2e4 \ud06c\uba74 While \ub8e8\ud504\ub97c \uc885\ub8cc\ud569\ub2c8\ub2e4.\nDebug.Print Counter        ' \uc9c1\uc811 \uc2e4\ud589<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.7._\ubc18\ubcf5\ubb38_\uc81c\uc5b4(Exit,_Continue)\"><span class=\"ez-toc-section\" id=\"327_%EB%B0%98%EB%B3%B5%EB%AC%B8_%EC%A0%9C%EC%96%B4Exit_Continue\"><\/span>3.2.7. \ubc18\ubcf5\ubb38 \uc81c\uc5b4(Exit, Continue)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ubc18\ubcf5\ubb38 \uc218\ud589 \uc911 \ud2b9\uc815 \uc870\uac74\uc77c \ub54c \ubc18\ubcf5\uc744 \uc911\ub2e8\ud558\ub294 \uad6c\ubb38\uc740 Exit For\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \ud558\uc9c0\ub9cc, \ubc18\ubcf5\uc744 skip\ud558\ub294 continue \uad6c\ubb38\uc740 VBA\uc5d0\uc11c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4. IF block \ub610\ub294 Goto \uad6c\ubb38\uc73c\ub85c \uc81c\uc5b4\ud55c\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"If_block_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span><strong>If block \uc0ac\uc6a9 \ubc29\ubc95<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>\ud2b9\uc815 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uad6c\ubb38\uc774 \uc2e4\ud589\ub418\ub3c4\ub85d If block\uc73c\ub85c \uac10\uc2f8\ub294 \ubc29\ubc95<\/li><li>\ucf54\ub4dc\uc758 \ucd08\uae30\uc5d0 \ud655\uc815\ub41c \ubcc0\uc218\uac12\uc744 \uae30\uc900\uc73c\ub85c continue \ucc98\ub9ac\ub97c \ud558\ub294 \uacbd\uc6b0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc74c<\/li><li>\uc870\uac74\uc774&nbsp;\ubcf5\uc7a1\ud558\uac70\ub098&nbsp;\ucd08\uae30\uc5d0&nbsp;\ubcc0\uc218\uac12\uc774&nbsp;\ud655\uc815\ub418\uc9c0&nbsp;\uc54a\ub294\ub2e4\uba74&nbsp;\uc0ac\uc6a9\ud558\uae30&nbsp;\uc5b4\ub824\uc6c0<\/li><\/ul>\n\n\n\n<p><\/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=\"\">For iSht = 1 To aBook.Worksheets.Count\n    Set oSht = aBook.Sheets(iSht)\n\u00a0\n    If (IsColumnMappingSheet(oSht)) and (lRowOffset >= 0)\n        ...\n        ...\n    End If\nNext iSht<\/pre>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Goto_%EC%82%AC%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span><strong>Goto \uc0ac\uc6a9 \ubc29\ubc95<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>\ucf54\ub4dc\uc758 \uc911\uac04 \uc911\uac04\uc5d0 \uacc4\uc0b0 \ub610\ub294 \ud2b9\uc815 \uc870\uac74\uc5d0 \uc758\ud574 continue \ucc98\ub9ac\ub97c \ud558\ub294 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9\ud568<\/li><li>Loop\uc758 \uac00\uc7a5 \uc544\ub798\ucabd(Next \ubc14\ub85c \uc704)\uc5d0 \uc774\ub3d9\ud560 \uc704\uce58\ub97c label\ub85c \uc9c0\uc815\ud558\uace0 If \uc870\uac74\ubb38\uc5d0\uc11c Goto \uad6c\ubb38 \uc0ac\uc6a9<\/li><li>\uc2dc\uc791, \uc911\uac04 \uc5b4\ub290 \ubd80\ubd84\uc5d0\uc11c\ub098 \uc0ac\uc6a9\uac00\ub2a5\ud568<\/li><\/ul>\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=\"\">For iSht = 1 To aBook.Worksheets.Count\n    Set oSht = aBook.Sheets(iSht)\n\u00a0\n    If Not IsColumnMappingSheet(oSht) Then GoTo Continue_To_Next_Sheet\n    ...\n    If lRowOffset &lt; 0 Then GoTo Continue_To_Next_Sheet\n    ...\nContinue_To_Next_Sheet:\nNext iSht<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.8._\ud504\ub85c\uc2dc\uc838(Procedure)\"><span class=\"ez-toc-section\" id=\"328_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8Procedure\"><\/span>3.2.8. \ud504\ub85c\uc2dc\uc838(Procedure)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\ud504\ub85c\uc2dc\uc838\ub294 \ub300\ud45c\uc801\uc73c\ub85c Sub, Function\uc774 \uc788\ub2e4.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sub_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_%EB%AC%B8%EB%B2%95\"><\/span><strong>Sub \ud504\ub85c\uc2dc\uc838 \ubb38\ubc95<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">[Private | Public] [Static] Sub name [(arglist)]\n    [statements]\n    [Exit Sub]\n    [statements]\nEnd Sub<\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131 \uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><strong>Public<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;\ubaa8\ub4c8\ub0b4\uc758 \ubaa8\ub4e0 \ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \ud574\ub2f9&nbsp;<strong>Sub&nbsp;<\/strong>\ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud560 \uc218 \uc788\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ub9cc\uc57d&nbsp;<strong>Option Private&nbsp;<\/strong>\ubb38\uc774 \uc788\ub294 \ubaa8\ub4c8\uc5d0\uc11c \uc0ac\uc6a9\ud55c\ub2e4\uba74 \uadf8 \ud504\ub85c\uc2dc\uc800\ub97c&nbsp;\ud504\ub85c\uc81d\ud2b8&nbsp;\uc678\ubd80\uc5d0\uc11c \ud638\ucd9c\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>Private<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Sub&nbsp;<\/strong>\ud504\ub85c\uc2dc\uc800\ub294 \uc120\uc5b8\ub41c \ubaa8\ub4c8 \ub0b4\uc758 \ub2e4\ub978 \ud504\ub85c\uc2dc\uc800\uc5d0\uc11c\ub9cc \ud638\ucd9c\ud560 \uc218 \uc788\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>Friend<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;\ud074\ub798\uc2a4 \ubaa8\ub4c8\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ub429\ub2c8\ub2e4.&nbsp;<strong>Sub<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\uac00 \ud504\ub85c\uc81d\ud2b8 \uc804\uccb4\uc5d0\uc11c \uc778\uc2dd\ub418\uc9c0\ub9cc \uac1c\uccb4\uc758 \uc778\uc2a4\ud134\uc2a4 \ucee8\ud2b8\ub864\ub7ec\uc5d0\uc11c\ub294 \uc778\uc2dd\ub420 \uc218 \uc5c6\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>Static<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Sub&nbsp;<\/strong>\ud504\ub85c\uc2dc\uc800\uc758 \uc9c0\uc5ed&nbsp;\ubcc0\uc218\uac00 \ud568\uc218 \ud638\ucd9c\ub9c8\ub2e4 \uc720\uc9c0\ub428\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \uc0ac\uc6a9\ub418\uc5b4\ub3c4&nbsp;<strong>Sub&nbsp;<\/strong>\ubc16\uc5d0\uc11c \uc120\uc5b8\ub41c \ubcc0\uc218\ub294<strong>&nbsp;Static&nbsp;<\/strong>\uc18d\uc131\uc744 \uac16\uc9c0 \ubabb\ud569\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>name<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Sub<\/strong>&nbsp;\uc774\ub984\uc774\uba70, \ud45c\uc900 \ubcc0\uc218 \uba85\uba85 \uaddc\uce59\uc744 \ub530\ub985\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>arglist<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \ud638\ucd9c\ub420 \ub54c&nbsp;<strong>Sub&nbsp;<\/strong>\ud504\ub85c\uc2dc\uc800\uc5d0\uac8c \uc804\ub2ec\ub418\ub294 \uc778\uc218\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc0\uc218 \ubaa9\ub85d\uc785\ub2c8\ub2e4. \ub2e4\uc218\uc758 \ubcc0\uc218\uc77c \uacbd\uc6b0\ucf64\ub9c8(,) \uae30\ud638\ub85c \ubd84\ub9ac\ud569\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>statements<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Sub<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \uc2e4\ud589\ub418\ub294&nbsp;\ubb38\uc758 \uc9d1\ud569\uc785\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><em>arglist&nbsp;<\/em>\uc778\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uc131 \uc694\uc18c\ub85c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>[<strong>Optional<\/strong>] [<strong>ByVal<\/strong>&nbsp;|&nbsp;<strong>ByRef<\/strong>] [<strong>ParamArray<\/strong>]&nbsp;<em>varname<\/em>[<strong>( )<\/strong>] [<strong>As<\/strong>&nbsp;<em>type<\/em>] [<strong>=<\/strong>&nbsp;<em>defaultvalue<\/em>]<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131 \uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><strong>Optional<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc778\uc218\uac00 \ud544\uc218\uac00 \uc544\ub2d8\uc744 \ub098\ud0c0\ub0b4\ub294&nbsp;\ud0a4\uc6cc\ub4dc\uc785\ub2c8\ub2e4.&nbsp;<strong>Optional<\/strong>\uc744 \uc0ac\uc6a9\ud558\uba74&nbsp;<em>arglist<\/em>\uc5d0 \uc0ac\uc6a9\ub41c \uc778\uc218\ub294 \ubaa8\ub450 \uc120\ud0dd \uc0ac\ud56d\uc774\uba70&nbsp;<em>Optional<\/em>&nbsp;\ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc120\uc5b8\ud574\uc57c \ud569\ub2c8\ub2e4. \ubaa8\ub4e0&nbsp;<em>Optional&nbsp;<\/em>\uc778\uc218\ub294&nbsp;<em>Variant<\/em>\uc774\uc5b4\uc57c \ud558\uba70<em>&nbsp;Optional<\/em>\uc740&nbsp;<strong>ParamArray<\/strong>\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>ByVal<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc778\uc218\uac00&nbsp;\uac12\uc5d0 \uc758\ud55c \uc804\ub2ec\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>ByRef<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc778\uc218\uac00&nbsp;\ucc38\uc870\uc5d0 \uc758\ud55c \uc804\ub2ec\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. Visual Basic\uc5d0\uc11c\ub294&nbsp;<strong>ByRef<\/strong>\uac00 \uae30\ubcf8\uac12\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>ParamArray<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<em>arglist<\/em>\uc5d0\uc11c \ub9c8\uc9c0\ub9c9 \uc778\uc218\ub85c \uc0ac\uc6a9\ub418\uba70 \ub9c8\uc9c0\ub9c9 \uc778\uc218\uac00&nbsp;<strong>Variant&nbsp;<\/strong>\uc694\uc18c\uc758&nbsp;<strong>Optional<\/strong>&nbsp;\ubc30\uc5f4\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.&nbsp;<strong>ParamArray&nbsp;<\/strong>\ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 \uc784\uc758 \uac1c\uc218\uc758 \uc778\uc218\ub4e4\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70,<strong>&nbsp;ByVal<\/strong>,&nbsp;<strong>ByRef<\/strong>&nbsp;\ub610\ub294&nbsp;<strong>Optional<\/strong>\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>varname<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \uc778\uc218\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc0\uc218\uc758 \uc774\ub984\uc744 \ub9d0\ud558\uba70 \ud45c\uc900 \ubcc0\uc218 \uba85\uba85 \uaddc\uce59\uc744 \ub530\ub985\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>type<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \ud504\ub85c\uc2dc\uc800\uc5d0 \uc804\ub2ec\ub418\ub294 \uc778\uc218\uc758&nbsp;\ub370\uc774\ud130 \ud615\uc2dd\uc744 \ub9d0\ud558\uba70 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.&nbsp;Byte,&nbsp;Boolean,&nbsp;Integer,&nbsp;Long,&nbsp;Currency,&nbsp;Single,&nbsp;Double,&nbsp;Decimal(\ud604\uc7ac\ub294 \uc9c0\uc6d0 \uc548\ud568),&nbsp;Date,&nbsp;String(\uac00\ubcc0 \uae38\uc774 \ubb38\uc790\uc5f4\ub9cc \uac00\ub2a5),&nbsp;Object,&nbsp;Variant\ub9e4\uac1c \ubcc0\uc218\uac00&nbsp;<strong>Optional<\/strong>\uc774 \uc544\ub2c8\uba74,&nbsp;\uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd\uacfc&nbsp;\uac1c\uccb4 \ud615\uc2dd\uc744 \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>defaultvalue<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;\uc0c1\uc218&nbsp;\ud639\uc740 \uc0c1\uc218&nbsp;\uc2dd\uc774\uba70,&nbsp;<strong>Optional&nbsp;<\/strong>\ub9e4\uac1c \ubcc0\uc218\uc77c \uacbd\uc6b0\ub9cc \uc720\ud6a8\ud569\ub2c8\ub2e4.&nbsp;<strong>Object&nbsp;<\/strong>\ud615\uc2dd\uc77c \uacbd\uc6b0 \uba85\uc2dc\uc801\uc778 \uae30\ubcf8\uac12\uc73c\ub85c\ub294&nbsp;<strong>Nothing<\/strong>\ub9cc \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/sub-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/sub-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sub_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_sample_code\"><\/span>Sub \ud504\ub85c\uc2dc\uc838 sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">' \ud558\uc704 \ud504\ub85c\uc2dc\uc800 \uc815\uc758\uc785\ub2c8\ub2e4.\n' \ub450\uac1c\uc758 \uc778\uc218\ub97c \uac00\uc9c4 \ud558\uc704 \ud504\ub85c\uc2dc\uc800\uc785\ub2c8\ub2e4.\nSub SubComputeArea(Length, TheWidth)\n    Dim Area As Double    ' \uc9c0\uc5ed \ubcc0\uc218\ub97c \uc120\uc5b8\ud569\ub2c8\ub2e4.\n    If Length = 0 Or TheWidth = 0 Then\n    ' \ub9cc\uc57d \ub450 \uc778\uc218\uac00 \ubaa8\ub450 0\uc774\uba74,\n        Exit Sub    ' Sub\ub97c \uc989\uc2dc \uc885\ub8cc\ud569\ub2c8\ub2e4.\n    End If\n    Area = Length * TheWidth    ' \uc0ac\uac01\ud615\uc758 \uba74\uc801\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4.\n    Debug.Print Area    ' \uc9c0\uc5ed\uc744 \ub514\ubc84\uadf8 \ucc3d\uc5d0 \uc778\uc1c4\ud569\ub2c8\ub2e4.\nEnd Sub<\/pre>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Function_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_%EB%AC%B8%EB%B2%95\"><\/span><strong>Function \ud504\ub85c\uc2dc\uc838 \ubb38\ubc95<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">[Public | Private | Friend] [Static] Function name [(arglist)] [As type]\n    [statements]\n    [name = expression]\n    [Exit Function] \n    [statements]\n    [name = expression]\nEnd Function<\/pre>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131 \uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><strong>Public<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\ub294 \ubaa8\ub4e0&nbsp;\ubaa8\ub4c8\uc758 \ubaa8\ub4e0 \ud504\ub85c\uc2dc\uc800\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ud504\ub85c\uc2dc\uc800\uac00<strong>&nbsp;Option Private<\/strong>\uc744 \uac16\uace0 \uc788\ub294 \ubaa8\ub4c8\uc5d0\uc11c \uc0ac\uc6a9\ub418\uba74&nbsp;\ud504\ub85c\uc81d\ud2b8&nbsp;\ubc16\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>Private<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\ub294 \uc774 \ud504\ub85c\uc2dc\uc800\uac00 \uc120\uc5b8\ub41c \ubaa8\ub4c8\uc5d0\uc11c\ub9cc \ub2e4\ub978 \ud504\ub85c\uc2dc\uc800\uc5d0 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>Friend<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;\ud074\ub798\uc2a4 \ubaa8\ub4c8\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ub429\ub2c8\ub2e4.&nbsp;<strong>Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\uac00 \ud504\ub85c\uc81d\ud2b8 \uc804\uccb4\uc5d0\uc11c \uc778\uc2dd\ub418\uc9c0\ub9cc \uac1c\uccb4\uc758 \uc778\uc2a4\ud134\uc2a4 \ucee8\ud2b8\ub864\ub7ec\uc5d0\uc11c\ub294 \uc778\uc2dd\ub420 \uc218 \uc5c6\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>Static<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\uc758 \uc9c0\uc5ed&nbsp;\ubcc0\uc218\uac00 \ud638\ucd9c \ub0b4\uc5d0\uc11c \ubcf4\uc874\ub428\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.&nbsp;<strong>Static<\/strong>&nbsp;\uc18d\uc131\uc740&nbsp;<strong>Function<\/strong>&nbsp;\ubc16\uc5d0\uc11c \uc120\uc5b8\ub41c \ubcc0\uc218\uac00 \ud504\ub85c\uc2dc\uc800\uc5d0\uc11c \uc0ac\uc6a9\ub41c\ub2e4 \ud558\ub354\ub77c\ub3c4 \uc774 \ubcc0\uc218\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>name<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Function<\/strong>\uc758 \uc774\ub984\uc774\uba70 \ud45c\uc900 \ubcc0\uc218 \uba85\uba85 \uaddc\uce59\uc5d0 \ub530\ub985\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>arglist<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \ud638\ucd9c\ud558\uba74&nbsp;<strong>Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\uc5d0 \uc804\ub2ec\ub418\ub294 \uc778\uc218\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc0\uc218\uc758 \ubaa9\ub85d\uc785\ub2c8\ub2e4. \ubcc0\uc218\uac00 \uc5ec\ub7ec \uac1c\uc778 \uacbd\uc6b0\uc5d0\ub294 \uc27c\ud45c\ub85c \uad6c\ubd84\ub429\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>type<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.<strong>&nbsp;Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800\uc5d0 \uc758\ud574 \ubc18\ud658\ub418\ub294 \uac12\uc758&nbsp;\ub370\uc774\ud130 \ud615\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.&nbsp;Byte,&nbsp;Boolean,&nbsp;Integer,&nbsp;Long,&nbsp;Currency,&nbsp;Single,&nbsp;Double,&nbsp;Decimal(\ud604\uc7ac \uc9c0\uc6d0 \uc548\ub428),&nbsp;Date,&nbsp;String,(\uac00\ubcc0 \uae38\uc774 \uc81c\uc678),Object,&nbsp;Variant,&nbsp;\uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd<\/td><\/tr><tr><td><em>statements<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Function<\/strong>&nbsp;\ud504\ub85c\uc2dc\uc800 \ub0b4\ubd80\uc5d0\uc11c \uc2e4\ud589\ub420 \uba85\ub839\ubb38\uc758 \uadf8\ub8f9\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>expression<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<strong>Function<\/strong>&nbsp;\uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><em>arglist<\/em>&nbsp;\uc778\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\ubb38\uacfc \uad6c\uc131 \uc694\uc18c\ub97c \uac00\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n<p>[<strong>Optional<\/strong>] [<strong>ByVal<\/strong>&nbsp;|&nbsp;<strong>ByRef<\/strong>] [<strong>ParamArray<\/strong>]&nbsp;<em>varname<\/em>[<strong>( )<\/strong>] [<strong>As<\/strong>&nbsp;<em>type<\/em>] [<strong>=<\/strong>&nbsp;<em>defaultvalue<\/em>]<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\uc131 \uc694\uc18c<\/td><td>\uc124\uba85<\/td><\/tr><tr><td><strong>Optional<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc778\uc218\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc778\uc218\uac00 \uc0ac\uc6a9\ub418\ub824\uba74&nbsp;<em>arglist<\/em>\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ub2e4\uc74c \uc778\uc218\ub4e4\uc744 \uc120\ud0dd\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\uba70&nbsp;<strong>Optional<\/strong>&nbsp;\ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc120\uc5b8\ud574\uc57c \ud569\ub2c8\ub2e4. \ub9cc\uc57d&nbsp;<strong>ParamArray<\/strong>\uac00 \uc0ac\uc6a9\ub418\uba74&nbsp;<strong>Optional<\/strong>\uc740 \uc5b4\ub5a4 \uc778\uc218\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc0ac\uc6a9\ub420 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>ByVal<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc778\uc218\uac00&nbsp;\uac12\uc5d0 \uc758\ud55c \uc804\ub2ec\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>ByRef<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \uc778\uc218\uac00&nbsp;\ucc38\uc870\uc5d0 \uc758\ud55c \uc804\ub2ec\uc784\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. Visual Basic\uc5d0\uc11c\ub294&nbsp;<strong>ByRef<\/strong>\uac00 \uae30\ubcf8\uac12\uc785\ub2c8\ub2e4.<\/td><\/tr><tr><td><strong>ParamArray<\/strong><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \ub9c8\uc9c0\ub9c9 \uc778\uc218\uac00&nbsp;<strong>Variant<\/strong>&nbsp;\uc694\uc18c\uc758&nbsp;<strong>Optional<\/strong>&nbsp;\ubc30\uc5f4\uc784\uc744 \ub098\ud0c0\ub0b4\ub3c4\ub85d&nbsp;<em>arglist<\/em>\uc5d0 \uc788\ub294 \ub9c8\uc9c0\ub9c9 \uc778\uc218\ub85c\uc11c\ub9cc \uc0ac\uc6a9\ub429\ub2c8\ub2e4.&nbsp;<strong>ParamArray<\/strong>&nbsp;\ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 \uc784\uc758 \uac1c\uc218\uc758 \uc778\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, \uc774 \ud0a4\uc6cc\ub4dc\ub294&nbsp;<strong>ByVal<\/strong>,&nbsp;<strong>ByRef<\/strong>,&nbsp;<strong>Optional<\/strong>\uacfc \ud568\uaed8 \uc0ac\uc6a9\ub420 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>varname<\/em><\/td><td>\ud544\uc218\uc801\uc778 \uc694\uc18c. \uc778\uc218\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc0\uc218\uc758 \uc774\ub984\uc774\uba70 \ud45c\uc900 \ubcc0\uc218 \uba85\uba85 \uaddc\uce59\uc5d0 \ub530\ub985\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>type<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c. \ud504\ub85c\uc2dc\uc800\uc5d0 \uc804\ub2ec\ub418\ub294 \uc778\uc218\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc740&nbsp;<strong>Byte<\/strong>,&nbsp;<strong>Boolean<\/strong>,&nbsp;<strong>Integer<\/strong>,&nbsp;<strong>Long<\/strong>,&nbsp;<strong>Currency<\/strong>,&nbsp;<strong>Single<\/strong>,&nbsp;<strong>Double<\/strong>,&nbsp;<strong>Decimal<\/strong>(\ud604\uc7ac \uc9c0\uc6d0 \uc548\ub428)&nbsp;<strong>Date<\/strong>,&nbsp;<strong>String&nbsp;<\/strong>(\uac00\ubcc0 \uae38\uc774\uc758 \uacbd\uc6b0),&nbsp;<strong>Object<\/strong>,&nbsp;<strong>Variant<\/strong>, \ud2b9\uc815\ud55c&nbsp;\uac1c\uccb4 \ud615\uc2dd&nbsp;\ub4f1\uc774 \ub429\ub2c8\ub2e4. \ub9e4\uac1c \ubcc0\uc218\uac00&nbsp;<strong>Optional<\/strong>\uc774 \uc544\ub2c8\ub77c\uba74 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud615\uc2dd\ub3c4 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td><\/tr><tr><td><em>defaultvalue<\/em><\/td><td>\uc120\ud0dd\uc801\uc778 \uc694\uc18c.&nbsp;<a>\uc0c1\uc218<\/a>\ub098 \uc0c1\uc218\uc2dd\uc774\uba70&nbsp;<strong>Optional<\/strong>&nbsp;\ub9e4\uac1c \ubcc0\uc218\uc5d0 \ub300\ud574\uc11c\ub9cc \uc720\ud6a8\ud569\ub2c8\ub2e4. \ud615\uc2dd\uc774&nbsp;<strong>Object<\/strong>\uba74 \uba85\uc2dc\uc801 \uae30\ubcf8\uac12\uc740&nbsp;<strong>Nothing<\/strong>\uc73c\ub85c\ub9cc \ub429\ub2c8\ub2e4.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>* \ucc38\uace0<\/strong>: \uc704 \ub0b4\uc6a9\uc740 \ud55c\uae00\ub85c \ubc88\uc5ed\ub41c chm \ub3c4\uc6c0\ub9d0\uc5d0\uc11c \ubc1c\ucdcc\ud558\uc600\ub2e4. \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc740 \uc544\ub798 URL\uc744 \ucc38\uace0\ud55c\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/function-statement\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/function-statement<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Function_%ED%94%84%EB%A1%9C%EC%8B%9C%EC%A0%B8_sample_code\"><\/span>Function \ud504\ub85c\uc2dc\uc838 sample code<span class=\"ez-toc-section-end\"><\/span><\/h5>\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=\"\">' \ub2e4\uc74c\uc758 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218\ub294\n' \uc804\ub2ec\ub41c \uc778\uc218\uc758 \uc81c\uacf1\uadfc\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.\nFunction CalculateSquareRoot(NumberArg As Double) As Double\n    If NumberArg &lt; 0 Then    ' \uc778\uc218\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4.\n        Exit Function    ' \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c\uc744 \uc885\ub8cc\ud569\ub2c8\ub2e4.\n    Else\n        CalculateSquareRoot = Sqr(NumberArg)    ' \uc81c\uacf1\uadfc\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.\n    End If\nEnd Function<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.9._\uc624\ub958_\ucc98\ub9ac\"><span class=\"ez-toc-section\" id=\"329_%EC%98%A4%EB%A5%98_%EC%B2%98%EB%A6%AC\"><\/span>3.2.9. \uc624\ub958 \ucc98\ub9ac<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Java, C#\uc5d0\uc11c\uc758 try, catch, finally \uad6c\ubb38\uc740 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\ub294\ub2e4. On Error Goto \uad6c\ubb38\uc73c\ub85c \uc624\ub958\ub97c \ucc98\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\uad6c\ubb38<\/td><td>\uc124\uba85<\/td><\/tr><tr><td>On Error&nbsp;GoTo&nbsp;label<\/td><td>\uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uba74 \uc9c0\uc815\ud55c&nbsp;label\ub85c \uc2e4\ud589 \uc704\uce58 \uc774\ub3d9<\/td><\/tr><tr><td>On Error&nbsp;Resume Next<\/td><td>\ubc1c\uc0dd\ud55c \uc624\ub958\ub97c \ubb34\uc2dc\ud558\uace0 \ub2e4\uc74c \uba85\ub839\uc73c\ub85c \uacc4\uc18d \uc2e4\ud589<\/td><\/tr><tr><td>On Error&nbsp;GoTo&nbsp;0<\/td><td>\uc124\uc815\ub41c \uc624\ub958 \ucc98\ub9ac \ubc29\uc2dd(Goto,&nbsp;Resume)\uc744 \ucd08\uae30\ud654<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\uc624\ub958 \ucc98\ub9ac \uae30\ubcf8 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/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=\"\">Sub ErrorTest()\n    On Error GoTo ErrHandler 'Error \ucc98\ub9ac \uc2dc\uc791 (=try)\n\u00a0\n    Dim i As Integer\n    i = 1 \/ 0\n\u00a0\n    On Error GoTo 0 'Error \ucc98\ub9ac \uc885\ub8cc (=finally)\n\u00a0\n    Exit Sub\n    \nErrHandler:  'Error \ucc98\ub9ac (=catch)\n    MsgBox Err.Description\nEnd Sub<\/pre>\n\n\n\n<p>\uc704 \ucf54\ub4dc\ub294 \uc77c\ubd80\ub7ec 0\uc73c\ub85c \ub098\ub204\uae30 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ucf1c\uc11c ErrHandler \uc601\uc5ed\uc758 \uad6c\ubb38\uc774 \uc2e4\ud589\ub41c\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.10._VB(Visual_Basic)_\uc124\uba85\uc11c_\ub3c4\uc6c0\ub9d0(CHM)\"><span class=\"ez-toc-section\" id=\"3210_VBVisual_Basic_%EC%84%A4%EB%AA%85%EC%84%9C_%EB%8F%84%EC%9B%80%EB%A7%90CHM\"><\/span>3.2.10. VB(Visual Basic) \uc124\uba85\uc11c \ub3c4\uc6c0\ub9d0(CHM)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>CHM(Compiled HTML Help) \ud30c\uc77c\ub85c \uc791\uc131\ub41c \ud55c\uae00 Visual Basic \uc124\uba85\uc11c\ub97c \uc608\uc804\uc5d0 \ubc1b\uc544 \ub450\uc5c8\ub294\ub370, \ucd9c\ucc98\ub294 \uc54c \uc218 \uc5c6\ub2e4. Visual Studio 6.0\uc5d0 \ud3ec\ud568\ub41c \ub3c4\uc6c0\ub9d0 \ud30c\uc77c\uc778 \uac83\uc73c\ub85c \ubcf4\uc778\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-5c487cd5-01f5-45aa-a51c-1c6742b4c259\" href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/Visual-Basic-\uc124\uba85\uc11c\ud55c\uae00.zip\">Visual Basic \uc124\uba85\uc11c(\ud55c\uae00)<\/a><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/Visual-Basic-\uc124\uba85\uc11c\ud55c\uae00.zip\" class=\"wp-block-file__button\" download aria-describedby=\"wp-block-file--media-5c487cd5-01f5-45aa-a51c-1c6742b4c259\">\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\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-91.png\"><img loading=\"lazy\" decoding=\"async\" width=\"673\" height=\"595\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91.png\" alt=\"Visual Basic \uc124\uba85\uc11c(CHM)\" class=\"wp-image-11379\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91.png 673w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91-300x265.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91-24x21.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91-36x32.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-91-48x42.png 48w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/a><figcaption>Visual Basic \uc124\uba85\uc11c(CHM)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>\ubc14\uc774\ub7ec\uc2a4\ub4f1\uc774 \uac71\uc815\ub41c\ub2e4\uba74 \uc774 \ud30c\uc77c\uc740 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc9c0 \uc54a\uace0 \uc628\ub77c\uc778 \ub3c4\uc6c0\ub9d0\uc744 \uc774\uc6a9\ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<p>\uc774 \ud30c\uc77c\uc740 \uc5f4\uae30 \uc804\uc5d0 \ucc28\ub2e8\uc744 \ud574\uc81c\ud574 \uc918\uc57c \uc815\uc0c1\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \ud30c\uc77c\uc744 \uc120\ud0dd\ud558\uace0 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc \ud074\ub9ad, \uc18d\uc131\uc5d0\uc11c \uc6b0\uce21 \ud558\ub2e8 &#8220;\ucc28\ub2e8 \ud574\uc81c&#8221;\ub97c \uccb4\ud06c\ud558\uace0 \ud655\uc778\uc744 \ub204\ub978 \ub2e4\uc74c \ud30c\uc77c\uc744 \uc5f4\uba74 \ub41c\ub2e4. (\uc544\ub798 \uc774\ubbf8\uc9c0 \ucc38\uc870)<\/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-92.png\"><img loading=\"lazy\" decoding=\"async\" width=\"421\" height=\"580\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92.png\" alt=\"\ud30c\uc77c \uc18d\uc131, \ucc28\ub2e8 \ud574\uc81c \uccb4\ud06c\" class=\"wp-image-11380\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92.png 421w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92-218x300.png 218w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92-9x12.png 9w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92-17x24.png 17w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92-26x36.png 26w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-92-35x48.png 35w\" sizes=\"auto, (max-width: 421px) 100vw, 421px\" \/><\/a><figcaption>\ud30c\uc77c \uc18d\uc131, \ucc28\ub2e8 \ud574\uc81c \uccb4\ud06c<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"3.2.11._Office_2013_VBA_\uc124\uba85\uc11c(CHM,_\uc601\uc5b4)\"><span class=\"ez-toc-section\" id=\"3211_Office_2013_VBA_%EC%84%A4%EB%AA%85%EC%84%9CCHM_%EC%98%81%EC%96%B4\"><\/span>3.2.11. Office 2013 VBA \uc124\uba85\uc11c(CHM, \uc601\uc5b4)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Office 2013 \uc81c\ud488(Excel, Access, OneNote, Outlook, PowerPoint, Publisher, Visio, Word)\uc744 VBA\ub85c \ub2e4\ub8e8\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \uc124\uba85\uc11c\uc774\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=40326\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=40326<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93.png\" alt=\"Excel 2013 VBA documentation\" class=\"wp-image-11381\" width=\"840\" height=\"661\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93.png 1009w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93-300x236.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93-768x605.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93-24x19.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93-36x28.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-93-48x38.png 48w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><figcaption>Excel 2013 VBA documentation<\/figcaption><\/figure>\n\n\n\n<p>\uc704 URL\uc758 \ud558\ub2e8 Install Instructions\ub97c \ud3bc\uccd0\ubcf4\uba74 CHM \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc774 \ubcf4\uc774\uc9c0 \uc54a\uc744 \ub54c \uc870\uce58\ud558\ub294 \ubc29\ubc95\uc774 \uc124\uba85\ub418\uc5b4 \uc788\ub2e4. \uc774\uc804\uc5d0 \uc124\uba85\ud55c &#8220;\ucc28\ub2e8 \ud574\uc81c&#8221;\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4.<\/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-94.png\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"323\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94.png\" alt=\"Install Instructions\" class=\"wp-image-11382\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94.png 747w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94-300x130.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94-36x16.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-94-48x21.png 48w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/a><figcaption>Install Instructions<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Office 2013 \uc774\ud6c4 \ubc84\uc804\uc5d0 \ub300\ud55c \uc624\ud504\ub77c\uc778 \ub3c4\uc6c0\ub9d0(CHM)\uc740 \ucc3e\uc9c0 \ubabb\ud588\ub294\ub370, \ud639\uc2dc \uac00\uc9c0\uace0 \uc788\uac70\ub098 URL\uc744 \uc54c\uace0 \uc788\ub2e4\uba74 \ub313\uae00\ub85c \ub0a8\uaca8\uc8fc\uae30 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\uc774 \uae00\uc5d0\uc11c\ub294 VBA \ubb38\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \ub0b4\uc6a9\uc73c\ub85c\ub9cc \ucd94\ub838\uace0, \uc774 \ubb38\ubc95\ub9cc \ud655\uc2e4\ud558\uac8c \uc774\ud574\ud558\uba74 \ub300\ubd80\ubd84 VBA \ucf54\ub4dc\ub294 \uc77d\uace0 \uc4f8\uc218 \uc788\ub2e4. \ub2e4\uc74c\uc5d0\ub294 \uc790\ub8cc\ud615(Data type)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt;&nbsp;\uad00\ub828 \uae00 \ubaa9\ub85d&nbsp;&gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-preface\/\">\uc5d1\uc140 VBA \uac15\uc88c\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4. (\uac15\uc88c\uc608\uace0, feat.\uc5d1\uc140 VBA\ub97c \uad8c\uc7a5\ud558\ub294 \uc774\uc720)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-1-overview\/\">\uc5d1\uc140 VBA \uac15\uc88c(1): \uc5d1\uc140 VBA \uac1c\uc694<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-2-basic\/\">\uc5d1\uc140 VBA \uac15\uc88c(2): \uc5d1\uc140 VBA \uae30\ucd08<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-3-object-model\/\">\uc5d1\uc140 VBA \uac15\uc88c(3): \uc5d1\uc140 Object Model<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-4-handling-object-model\/\">\uc5d1\uc140 VBA \uac15\uc88c(4): \uc5d1\uc140 Object Model \ub2e4\ub8e8\uae30<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">\uc5d1\uc140 VBA \uac15\uc88c(5): \uc5d1\uc140 \ud30c\uc77c \ud655\uc7a5\uc790, VBE, \uae00\uaf34 \uc124\uc815<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-6-variable\/\">\uc5d1\uc140 VBA \uac15\uc88c(6): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubcc0\uc218<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\">\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-8-datatype\/\">\uc5d1\uc140 VBA \uac15\uc88c(8): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\uc790\ub8cc\ud615(Data type), \uc790\ub8cc\uad6c\uc870(Data structure)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\">\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-10-self-developed-tools\/\">\uc5d1\uc140 VBA \uac15\uc88c(10): \uc5d1\uc140 VBA\ub85c \uac1c\ubc1c\ud558\uc5ec \uc0ac\uc6a9\uc911\uc778 \ub3c4\uad6c<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/excel-vba-lecture-toc\/\">\uc5d1\uc140 VBA \uac15\uc88c \uc804\uccb4 \ubaa9\ucc28<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u7740\u773c\u4e8e Excel VBA \u8bed\u8a00\u57fa\u7840\u77e5\u8bc6\u4e2d\u7684\u8bed\u6cd5\u3002\u8fd9\u662f\u4e0a\u4e00\u7bc7\u6587\u7ae0\u7684\u5ef6\u7eed\u3002 Excel VBA\u6559\u7a0b\uff08\u516d\uff09\uff1aExcel VBA\u8bed\u8a00\u57fa\u7840-\u53d8\u91cf 3.2\uff0e\u8bed\u8a00\u8bed\u6cd5 VBA \u8bed\u8a00\u8bed\u6cd5\u4e0e Visual Basic \u8bed\u6cd5\u76f8\u540c\u3002\u4f60\u4e0d\u9700\u8981\u4e00\u5f00\u59cb\u5c31\u77e5\u9053\u6240\u6709\u7684\u8bed\u6cd5\uff0c\u8fd9\u91cc\u603b\u7ed3\u7684\u8bed\u6cd5\u5c31\u8db3\u591f\u4e86\u3002\u5168\u90e8\u7684...<\/p>","protected":false},"author":1,"featured_media":11374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11373","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.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA\uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubb38\ubc95(Syntax)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc870\uac74\ubb38(IF, IIF, Select Case), \ubc18\ubcf5\ubb38(For, For Each, While), \ubc18\ubcf5\ubb38 \uc81c\uc5b4(Exit, Continue), \uc624\ub958\ucc98\ub9ac\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uacfc \ub3c4\uc6c0\ub9d0\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\/zh\/excel-vba-lecture-7-syntax\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA\uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubb38\ubc95(Syntax)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc870\uac74\ubb38(IF, IIF, Select Case), \ubc18\ubcf5\ubb38(For, For Each, While), \ubc18\ubcf5\ubb38 \uc81c\uc5b4(Exit, Continue), \uc624\ub958\ucc98\ub9ac\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uacfc \ub3c4\uc6c0\ub9d0\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T08:17:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:41:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png\" \/>\n\t<meta property=\"og:image:width\" content=\"847\" \/>\n\t<meta property=\"og:image:height\" content=\"746\" \/>\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=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)\",\"datePublished\":\"2022-09-11T08:17:38+00:00\",\"dateModified\":\"2022-10-11T02:41:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\"},\"wordCount\":868,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\",\"url\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png\",\"datePublished\":\"2022-09-11T08:17:38+00:00\",\"dateModified\":\"2022-10-11T02:41:54+00:00\",\"description\":\"\uc5d1\uc140 VBA\uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubb38\ubc95(Syntax)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc870\uac74\ubb38(IF, IIF, Select Case), \ubc18\ubcf5\ubb38(For, For Each, While), \ubc18\ubcf5\ubb38 \uc81c\uc5b4(Exit, Continue), \uc624\ub958\ucc98\ub9ac\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uacfc \ub3c4\uc6c0\ub9d0\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png\",\"width\":847,\"height\":746},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)\"}]},{\"@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\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@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\/zh\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA \u6559\u7a0b\uff087\uff09\uff1aExcel VBA \u8bed\u8a00\u57fa\u7840 - \u8bed\u6cd5 - \u751f\u4ea7\u529b\u6280\u80fd","description":"\u672c\u6587\u4ecb\u7ecd Excel VBA \u7684\u57fa\u672c\u8bed\u6cd5\u3002\u60a8\u5c06\u627e\u5230\u6709\u5173\u6761\u4ef6\u8bed\u53e5\uff08IF\u3001IIF\u3001Select Case\uff09\u3001\u5faa\u73af\uff08For\u3001For Each\u3001While\uff09\u3001\u5faa\u73af\u63a7\u5236\uff08Exit\u3001Continue\uff09\u548c\u9519\u8bef\u5904\u7406\u7684\u4fe1\u606f\u548c\u5e2e\u52a9\u3002.","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\/zh\/excel-vba-lecture-7-syntax\/","og_locale":"zh_CN","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA\uc5b8\uc5b4 \uae30\ubcf8 \uc911 \ubb38\ubc95(Syntax)\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc870\uac74\ubb38(IF, IIF, Select Case), \ubc18\ubcf5\ubb38(For, For Each, While), \ubc18\ubcf5\ubb38 \uc81c\uc5b4(Exit, Continue), \uc624\ub958\ucc98\ub9ac\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uacfc \ub3c4\uc6c0\ub9d0\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/zh\/excel-vba-lecture-7-syntax\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T08:17:38+00:00","article_modified_time":"2022-10-11T02:41:54+00:00","og_image":[{"width":847,"height":746,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"Zerom","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"14 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)","datePublished":"2022-09-11T08:17:38+00:00","dateModified":"2022-10-11T02:41:54+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/"},"wordCount":868,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/","name":"Excel VBA \u6559\u7a0b\uff087\uff09\uff1aExcel VBA \u8bed\u8a00\u57fa\u7840 - \u8bed\u6cd5 - \u751f\u4ea7\u529b\u6280\u80fd","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png","datePublished":"2022-09-11T08:17:38+00:00","dateModified":"2022-10-11T02:41:54+00:00","description":"\u672c\u6587\u4ecb\u7ecd Excel VBA \u7684\u57fa\u672c\u8bed\u6cd5\u3002\u60a8\u5c06\u627e\u5230\u6709\u5173\u6761\u4ef6\u8bed\u53e5\uff08IF\u3001IIF\u3001Select Case\uff09\u3001\u5faa\u73af\uff08For\u3001For Each\u3001While\uff09\u3001\u5faa\u73af\u63a7\u5236\uff08Exit\u3001Continue\uff09\u548c\u9519\u8bef\u5904\u7406\u7684\u4fe1\u606f\u548c\u5e2e\u52a9\u3002.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-90.png","width":847,"height":746},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-7-syntax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(7): \uc5d1\uc140 VBA \uc5b8\uc5b4 \uae30\ubcf8-\ubb38\ubc95(Syntax)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"\u751f\u4ea7\u529b\u6280\u80fd","description":"\u5143\u601d\u7ef4\uff0c\u5143\u5de5\u4f5c","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":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"\u6cfd\u7f57\u59c6","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@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\/zh\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/comments?post=11373"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/posts\/11373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media\/11374"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/media?parent=11373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/categories?post=11373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/zh\/wp-json\/wp\/v2\/tags?post=11373"}],"curies":[{"name":"\u53ef\u6e7f\u6027\u7c89\u5242","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}