{"id":717,"date":"2022-11-14T14:42:47","date_gmt":"2022-11-14T05:42:47","guid":{"rendered":"https:\/\/chaerang.net\/?p=717"},"modified":"2022-11-14T14:42:47","modified_gmt":"2022-11-14T05:42:47","slug":"excel-vba-%eb%a7%a4%ed%81%ac%eb%a1%9cmacro%ec%99%80-vba%ec%9d%98-%ea%b8%b0%ec%b4%88","status":"publish","type":"post","link":"https:\/\/chaerang.net\/?p=717","title":{"rendered":"Excel – VBA : \ub9e4\ud06c\ub85c(Macro)\uc640 VBA\uc758 \uae30\ucd08"},"content":{"rendered":"\n

\uc548\ub155\ud558\uc2ed\ub2c8\uae4c \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub298\ub3c4 \ucde8\ubbf8\ud65c\ub3d9\uc744 \uc5d1\uc140\uc744 \uc62c\ub9b4 \uc608\uc815\uc785\ub2c8\ub2e4. \ub2e4\ub9cc, \ub108\ubb34 \uc218\uc2dd\ub9cc \ud558\ub2c8\uae4c \uc81c\uac00 \uc7ac\ubbf8\uac00 \uc5c6\uc5b4\uc9c0\ub294 \ub4ef\ud558\uc5ec VBA\ub97c \uc11e\uc5b4\uc11c \uc62c\ub9ac\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \u314e\u314e\u314e
\uc6d0\ub798 \uc81c \uc804\ubb38\uc740 \uc5d1\uc140 \uc218\uc2dd\ubcf4\ub2e4\ub294 VBA \ucabd\uc774\ub77c\uace0 \ud560\uae4c\uc694 ^^;;
\uc194\uc9c1\ud788 \uc804\ubb38\uae4c\uc9c0\ub294 \uc544\ub2c8\uad6c\uc694… \ub2e4\ub9cc \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1\uc744 \ub9ce\uc774 \uacf5\ubd80\ud588\ub358\ubc14 \uc788\uc5b4\uc11c, \ub2e4\ub978 \ubd84\ub4e4\ubcf4\ub2e4 \uc870\uae08 \ub354 \uae4a\uac8c \uc54c\uace0 \uc788\uc744 \uc815\ub3c4\uc785\ub2c8\ub2e4.
(\uadf8\ub798\ub3c4 \uc815\ubcf4\ucc98\ub9ac\uae30\uc0ac \uc790\uaca9\uc99d\uc740 \uc788\ub2e4\uad6c\uc694… \ud558\uae34 \uacf5\uacfc\ub300\ud559\uad50 \ub098\uc628 \uc0ac\ub78c \uc911\uc5d0 \uadf8\uac70 \uc5c6\ub294 \uc0ac\ub78c\uc774 \uba87\uc774\ub098 \ub41c\ub2e4\uace0 \u3160.\u3160)<\/p>\n\n\n\n

\uadf8\ub798\uc11c \uc624\ub298\uc740 VBA \uc785\ubb38\uc744 \uc704\ud55c \ub9e4\ud06c\ub85c \uc5f0\uacb0 \uae30\ucd08\ub97c \uc124\uba85 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc77c\ub2e8 VBA\ub97c \uc124\uba85\ub4dc\ub9ac\ub824\uba74 \ub9e4\ud06c\ub85c\ub97c \uba3c\uc800 \uc124\uba85\ub4dc\ub824\uc57c \ud569\ub2c8\ub2e4.
\uc5d1\uc140\uc5d0\uc11c \ub9e4\ud06c\ub85c \uae30\ub2a5\uc774\ub77c\uace0 \ud558\uba74, \uc77c\ub828\uc758 \ud589\ub3d9\uc744 \uadf8\ub300\ub85c \uae30\ub85d\ud574 \ub450\uc5c8\ub2e4\uac00,
\ub098\uc911\uc5d0 \uc2e4\ud589\ud558\uba74 \ub9e4\ud06c\ub85c\uc758 \uae30\ub85d\ub41c \uc791\uc5c5\uc774 \uadf8\ub300\ub85c \ubc18\ubcf5\ud558\ub294 \ud589\uc704\ub97c \ub9d0\ud569\ub2c8\ub2e4.
\uac8c\uc784\uc5d0\uc11c\ub3c4 \ub9e4\ud06c\ub85c\ub77c\ub294 \ub9d0\uc744 \uc4f0\ub294\ub370\uc694, \ub3d9\uc77c\ud558\uace0 \uac19\uc740 \uc791\uc5c5\uc744 \ubc18\ubcf5\ud558\ub294 \ud589\uc704\ub97c \ub73b\ud558\uc8e0.<\/p>\n\n\n\n

\ub9e4\ud06c\ub85c \uae30\ub2a5\uc740 \ubcf4\uae30 > \ub9e4\ud06c\ub85c > \ub9e4\ud06c\ub85c \uae30\ub85d\uc744 \ub204\ub974\uc2dc\uace0 \uc77c\ub828\uc758 \ud589\ub3d9\uc744 \ub9cc\ub4e4\uba74 \ub429\ub2c8\ub2e4.
\uc77c\ub2e8 \uac04\ub2e8\ud558\uac8c A1\uc5d0\ub294 “\ub9e4\ud06c\ub85c \ud14c\uc2a4\ud2b8”, B1\uc5d0\ub294 “2022-11-14″\uc744 \uae30\ub85d\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.
\uac04\ub2e8\ud558\uac8c \ubcf4\uae30 > \ub9e4\ud06c\ub85c > \ub9e4\ud06c\ub85c \uae30\ub85d\uc744 \ub204\ub974\uc2dc\uace0, \ub9e4\ud06c\ub85c \uc774\ub984\uc740 \ub9e4\ud06c\ub85c1\ub85c \uadf8\ub0e5 \ub450\uc2dc\uace0 \ud655\uc778\uc744 \ub204\ub974\uc138\uc694.
\uadf8 \ub2e4\uc74c\uc5d0 A1\uacfc B1\uc5d0 \uc9c0\uc815\ud55c \ubb38\uad6c\ub97c \ub123\uc73c\uc2dc\uace0, \ubcf4\uae30 > \ub9e4\ud06c\ub85c > \uae30\ub85d\uc911\uc9c0\ub97c \ub204\ub974\uc138\uc694.
\uadf8\ub7ec\uba74 \ud558\ub098\uc758 \ub9e4\ud06c\ub85c\uac00 \ub9cc\ub4e4\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 \uadf8\ub7fc \uc774 \ub9e4\ud06c\ub85c\ub97c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub290\ub0d0… \ubc14\ub85c \ubc84\ud2bc\uc744 \ub9cc\ub4e4\uc5b4\uc11c \uc0ac\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.
\ubc84\ud2bc\uc774\ub77c\uace0\ud574\uc11c \uac70\ucc3d\ud55c \uac83\uc740 \uc544\ub2c8\uad6c\uc694.
\uc0bd\uc785 > \ub3c4\ud615\uc5d0 \ub4e4\uc5b4\uac00\uc154\uc11c \uc544\ubb34\ubaa8\uc591\uc774\ub098 \ub123\uc73c\uc2dc\uba74\ub429\ub2c8\ub2e4. \uc800\ub294 \uc0ac\uac01\ud615 : \ube57\uba74(\ubc84\ud2bc \ubaa8\uc591)\uc744 \ub123\uc744 \uac81\ub2c8\ub2e4.
\uadf8\ub9ac\uace0 \ud574\ub2f9 \ub3c4\ud615\uc744 \ub9c8\uc6b0\uc2a4 \uc6b0\uce21 \ud074\ub9ad\ud558\uc2e0 \ud6c4 \ub9e4\ud06c\ub85c \uc9c0\uc815\uc744 \ub204\ub985\ub2c8\ub2e4.
\uadf8\ub9ac\uace0 \uc880\uc804\uc5d0 \uae30\ub85d\ud55c \ub9e4\ud06c\ub85c1(\uc774\ub984\uc744 \ubc14\uafb8\uc168\ub2e4\uba74 \ubc14\uafb8\uc2e0 \uc774\ub984\uc744 \uc120\ud0dd\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.)\uc744 \ub204\ub974\uc2dc\uace0 \ud655\uc778 \ubc84\ud2bc\uc744 \ub20c\ub7ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790, \uadf8\ub7fc \uc544\uae4c \ub123\uc5c8\ub358 A1\uc140\uacfc B1 \uc140\uc758 \ub0b4\uc6a9\uc744 \uc9c0\uc6b0\uc2dc\uace0, \ub9e4\ud06c\ub85c \ubc84\ud2bc\uc744 \ub20c\ub7ec\ubcf4\uc138\uc694.
\ucc38\uace0\ub85c \uccab\ubc88\uc9f8 \uac12\uc740 \ud604\uc7ac \uc9c0\uc815\ub418\uc5b4 \uc788\ub294 \uc140\uc5d0 \uc785\ub825\ub420 \ud655\ub960\uc774 \ud07d\ub2c8\ub2e4.
\uc65c\ub0d0\ud558\uba74, \ub9e4\ud06c\ub85c \uae30\ub85d\uc740 \uc785\ub825\uce78\uc744 \uae30\uc900\uc73c\ub85c \ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \ub9e4\ud06c\ub85c\ub97c \uc2dc\uc791\ud560 \ub54c\uc758 \uc140(\ud604\uc7ac \uc140)\uc774 \uae30\uc900\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.
\uadf8\ub798\uc11c \ub9cc\uc57d C1\uc5d0\uc11c \ub9e4\ud06c\ub85c\ub97c \uc2dc\uc791\ud55c\ub2e4\uba74, C1\uc5d0 “\ub9e4\ud06c\ub85c \ud14c\uc2a4\ud2b8”, B1\uc5d0 “2022-11-14″\ub77c\uace0 \uc785\ub825\ub420 \uac00\ub2a5\uc131\uc774 \ud07d\ub2c8\ub2e4.
\ub2e4\ub9cc, \ub9e4\ud06c\ub85c \uc2dc\uc791\ud560\ub300 A1\uc774 \uc544\ub2cc \ub2e4\ub978 \uc140\uc5d0\uc11c \uc2dc\uc791\ud558\uace0 A1\uc73c\ub85c \uc62e\uaca8\uc11c “\ub9e4\ud06c\ub85c \ud14c\uc2a4\ud2b8”\ub77c\uace0 \uc4f0\uc168\uc73c\uba74, A1\uc140\uc5d0 \ub370\uc774\ud130\uac00 \uc785\ub825\ub420 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc800\ub294 \uc5b4\ub514\uc5d0 \ub098\uc624\ub0d0\uad6c\uc694? \uc548 \uac00\ub974\uccd0\uc8fc\uae30 \uc704\ud574\uc11c A1\uc140\uc744 \ub204\ub974\uace0 \ubc84\ud2bc\uc744 \ub204\ub97c\uaebc\uc5d0\uc694 \u314b\u314b\u314b\u314b<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\uc774\ub7f0\uac8c \ub9e4\ud06c\ub85c \uae30\ub2a5\uc785\ub2c8\ub2e4. \ub2e4\ub9cc, \ub9e4\ud06c\ub85c \uae30\ub2a5\uc758 \uacbd\uc6b0 \ud55c\uacc4\uac00 \uba85\ud655\ud569\ub2c8\ub2e4.
\ub531 \uc9c0\uc815\ub41c \ud589\ub3d9\ub9cc \ud558\uae30 \ub54c\ubb38\uc5d0 \uc870\uac74\uc5d0 \ub530\ub978 \ub0b4\uc6a9\uc774\ub77c\ub358\uc9c0, \uc9c0\uc815\ub41c \uc0ac\uc720\uc5d0 \ub300\ud55c \uc785\ub825 \ub4f1\uc744 \ud560\uc218 \uc5c6\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.
\uadf8\ub798\uc11c \ub9e4\ud06c\ub85c\uc758 \uc0c1\uc704 \uae30\ub2a5\uc73c\ub85c VBA\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

VBA\ub294 Visual Basic For Applications\uc758 \uc57d\uc790\ub85c \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1 \uc5b8\uc5b4\ub97c \uc5d1\uc140\uc5d0\ub2e4\uac00 \uc735\ud569\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc77c\uc885\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc785\ub2c8\ub2e4.
\ub2e4\ub9cc, \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1 \uc5b8\uc5b4\ub294 \uacc4\uc18d \ubcc0\uacbd\ub418\ub294\ub370 \ubc18\ud574 \uc5d1\uc140\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 VBA\ub294 \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1 6.0 \ubc84\uc83c \uc218\uc900\uc5d0\uc11c \uba48\ucd94\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.
\uadf8 \uc810\uc740 \ucc38\uc870\ud558\uc5ec \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc77c\ub2e8, \uc624\ub298\uc740 VBA\uc758 \uae30\ucd08\ub9cc \uc54c\ub824\ub4dc\ub9b4 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \uae30\ub2a5\uc758 \uc2e4\ud589\ub9cc \uc54c\ub824\ub4dc\ub9ac\uace0 \ub05d\ub0b4\uaca0\uc2b5\ub2c8\ub2e4.
\ud2c8\ud2c8\uc774 \uc0ac\uc6a9\ud560\ub9cc\ud55c \uc218\uc2dd\ub4e4 \uc54c\ub824\ub4dc\ub9b4\uaed8\uc694. ^^
\uc544\ub2c8\uba74 \uc800\ud55c\ud14c \uac1c\uc778\uc801\uc73c\ub85c \uc9c8\ubb38\ud574 \uc8fc\uc2dc\uba74 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.
(\ud648\ud398\uc774\uc9c0 \uc624\ub978\ucabd \uc544\ub798\uc5d0 \ubcf4\uc2dc\uba74 \uad00\ub9ac\uc790 \ubb38\uc758\ub77c\uace0 \uac8c\uc2dc\ud310\uc774 \uc5f0\uacb0\ub418\uc5b4 \uc788\uc5b4\uc694. \uc5d1\uc140\ubb38\uc758\ub77c\uace0 \uc368 \uc8fc\uc2dc\uba74 \uc81c\uac00 \uc54c\uace0 \uc788\ub2e4\uba74 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n

\uc790 \uc624\ub298\uc740 A1\uc140\uc5d0 “VBA \ud14c\uc2a4\ud2b8”, B1\uc140\uc5d0 “2022-11-14″\uc744 \uc785\ub825\ud558\uace0, \uba54\uc138\uc9c0 \ubc15\uc2a4\ub97c \ub744\uc6cc “Welcome to VBA World”\ub97c \uc368 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\uc6f0\ucef4 \ubb38\uad6c\ub294 \ubaa8\ub4e0 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub97c \ubc30\uc6b8\ub54c \ucd5c\ucd08\ub85c \ubc30\uc6b0\ub294 \ubb38\uad6c \uc2dd\uc774\uc5d0\uc694 \u314e\u314e\u314e. \uadf8\ub798\uc11c \uc800\ub3c4 \uadf8\ub798\uc694(\uacf5\ub3cc\uc774\uc758 \ubcf8\ub2a5\uc785\ub2c8\ub2e4.)<\/p>\n\n\n\n

\uc77c\ub2e8 \uc5d1\uc140\uc5d0\uc11c Alt + F11\uc744 \ub20c\ub7ec\uc8fc\uc2dc\uba74 Microsoft Visual Basic for Applications – \ud1b5\ud569 \ubb38\uc11c1\uc774\ub77c\ub294 \ucc3d\uc774 \uc5f4\ub9ac\ub294 \uac78 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uc67c\ucabd\uc5d0 \ud504\ub85c\uc81d\ud2b8\ub77c\ub294 \ucc3d\uc5d0\ub294 \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ubaa8\ub4e0 \uc5d1\uc140 \ubb38\uc11c\ub4e4\uc774 \ub2e4 \ub098\ud0c0\ub098\uc694. \uadf8\uc911 VBA\ub97c \uc801\uc6a9\ud560 \ubb38\uc11c\ub97c \uc120\ud0dd\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.(\uc790\ub3d9\uc73c\ub85c \uc120\ud0dd\ub418\uc5b4 \uc788\uc5b4\uc694.)
\uc800\uae30\uc11c \ubaa8\ub4c8\uc774\ub77c\ub294 \ud3f4\ub354 \uc606\uc5d0 +\ub97c \ub204\ub974\uc2dc\uba74 Module 1\uc774\ub77c\ub294 \uac8c \ubcf4\uc77c\uac83\uc785\ub2c8\ub2e4. \uadf8\uac78 \ub354\ube14\ud074\ub9ad\ud558\uc2dc\uba74, \uc544\uae4c \uc2e4\ud589\ud55c \ub9e4\ud06c\ub85c1\uc758 \uc218\uc2dd\uc774 \ub098\ud0c0\ub0a0 \uac70\uc5d0\uc694.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uc800 \uc218\uc2dd\uc774 \ub9e4\ud06c\ub85c1\uc5d0 \uc800\uc7a5\ub41c \uc218\uc2dd\uc785\ub2c8\ub2e4.
\uc124\uba85\ud574 \ub4dc\ub9b4 \uc218\ub294 \uc788\uc73c\ub098, \ub098\uc911\uc5d0 \ud558\ub098\uc529 \uc54c\ub824\ub4dc\ub9ac\ub2e4 \ubcf4\uba74 \uc124\uba85\ub4dc\ub824\uc57c \ud558\ub294 \ub0b4\uc6a9\uc774\ub77c\uc11c, \uc624\ub298\uc740 \uadf8\ub0e5 \ud328\uc2a4\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc790 End Sub \ubc11\uc5d0 \uc5d4\ud130\ud0a4\ub97c \ub20c\ub7ec \uacf5\ubc31\uc744 \ub298\ub824\uc8fc\uc2dc\uad6c\uc694.
Sub VBA_Test()\ub77c\uace0 \uc785\ub825\ud558\uace0 \uc5d4\ud130\ud0a4\ub97c \ub20c\ub7ec\uc8fc\uc138\uc694.<\/p>\n\n\n\n

\uadf8\ub7ec\uba74 \uc774\uc804 End Sub \ubc11\uc5d0 \uc904\uc774 \ub098\ud0c0\ub098\uace0, \uc0c8\ub85c\uc6b4 End Sub\uac00 \ub098\ud0c0\ub098\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.
Sub\ub294 \ud558\uc704 \uba85\ub839\uc5b4\ub97c \uc2dc\uc791\ud55c\ub2e4\ub294 \uba85\ub839\uc774\uba70, End Sub\ub294 \ud574\ub2f9 \uba85\ub839\uc774 \ub05d\ub0ac\uc74c\uc744 \uc54c\ub9ac\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.
\uc989 Sub\uc640 End Sub \uc0ac\uc774\uc758 \ub0b4\uc6a9\uc774 VBA \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\ub294 \uad6c\ubb38\uc774 \ub418\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

A1\uc140\uacfc B1\uc140\uc5d0 \ub0b4\uc6a9\uc744 \uc785\ub825\ud558\ub294 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

Range(“A1”).Value = “VBA \ud14c\uc2a4\ud2b8”
Range(“B1”).Value = “2022-11-14”<\/p>\n\n\n\n

Range()\ub294 \ubc94\uc704\ub97c \uc120\ud0dd\ud558\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.
“A1” \ucc98\ub7fc \ud558\ub098\uc758 \uc140\uc744 \uc9c0\uc815\ud560\uc218\ub3c4 \uc788\uc9c0\ub9cc, “A1:A10″\ucc98\ub7fc \ubc94\uc704\ub97c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
\uadf8\ub9ac\uace0 \ub4a4\uc5d0 \uc788\ub294 .Value\ub294 \uc785\ub825\ub41c \uac12\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.
Range()\ub4a4\uc5d0 \uc810\uc744 \ucc0d\uc73c\uba74 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uba85\ub839\uc5b4\uac00 \uc5ec\ub7ec\uac1c \ub098\uc624\uac8c\ub429\ub2c8\ub2e4.
\uc774\uc911\uc5d0\uc11c .Value\ub294 \ud574\ub2f9 \ubc94\uc774\uc5d0 \ub4e4\uc5b4\uac00\ub294 \ub0b4\uc6a9\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.
(\ub098\uc911\uc5d0 \uc124\uba85\ud558\uaca0\uc9c0\ub9cc, \ubcf5\uc0ac\ub3c4 \ud560 \uc218 \uc788\uace0, \uc140 \uc11c\uc2dd\uc744 \ubc14\uafc0 \uc218\ub3c4 \uc788\uace0, \ubc94\uc704 \uc9c0\uc815\uc5d0\uc11c \ud560 \uc218 \uc788\ub294 \uc5ec\ub7ec\uac00\uc9c0 \uae30\ub2a5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n

\ub610\ud55c, Cells \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
Cells\uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \ub54c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

Cells(1,1).Value = “VBA \ud14c\uc2a4\ud2b8”
Cells(1,2).Value = “2022-11-14”<\/p>\n\n\n\n

Cells\uc758 \uba85\ub839\uc5b4 \ub4a4\uc5d0 \uc22b\uc790\ub294 \ubc18\ub4dc\uc2dc \ud589\uc774 \uba3c\uc800\uc774\uace0, \uc5f4\uc774 \ub098\uc911\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\uc989, A1\uc140\uc740 (1,1)\uc774\uc9c0\ub9cc, B1\uc740 (1,2)\uc785\ub2c8\ub2e4. – 1\ud589 1\uc5f4(A\uc5f4), 1\ud589 2\uc5f4(B\uc5f4)\uc784<\/p>\n\n\n\n

\uacb0\uacfc\ub294 \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uadf8\ub9ac\uace0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uba54\uc138\uc9c0 \ubc15\uc2a4\ub97c \ub744\uc6b0\ub294 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

msgbox “Welcome to VBA World”<\/p>\n\n\n\n

msgbox \ub4a4\uc5d0 \ub530\uc634\ud45c\ub97c \ub123\uc5b4\uc11c \uae00\uc790\ub97c \uc785\ub825\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \ud615\ud0dc\uc785\ub2c8\ub2e4.
\uc774 \uc678\uc5d0\ub3c4 \uc704\uc5d0\uc11c \uc0ac\uc6a9\ud55c Range()\ub098, Cells()\ub97c \uc0ac\uc6a9\ud558\uc5ec \uba54\uc138\uc9c0 \ubc15\uc2a4\ub97c \ub744\uc6b8\uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
\uc608\ub97c \ub4e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

msgbox Range(“A1”).Value<\/p>\n\n\n\n

\ucc38 \uc27d\uc8e0? \u314e\u314e\u314e\u314e \uc774\uac70 \ud574\ubcf4\uace0 \uc2f6\uc5c8\uc5b4\uc694. \uc608\uc804\uc5d0 \ubc25\ub85c\uc2a4 \uc544\uc800\uc528 \ubcf4\uba74\uc11c \u314b\u314b\u314b\u314b
\uc77c\ub2e8 \uc704\uc5d0 \ub0b4\uc6a9\uc744 \ubaa8\ub450 \ud3ec\ud568\ud558\uc5ec \uc81c\uac00 \ub9cc\ub4e0 VBA \uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\ubcf4\uc2dc\uba74 Sub \ubc11\uc5d0 \uc2dc\uc791\ud560\ub54c \ud0ed\uc73c\ub85c \ud55c\uce78 \uc548\uc73c\ub85c \ub4e4\uc5b4\uac04 \uac83\uc744 \ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
Sub \uc548\uc5d0 \uc788\ub294 \uba85\ub839\uc5b4\ub97c \uad6c\ubd84\ud558\uae30 \uc704\ud558\uc5ec \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4.
\uc624\ub298 \ud558\ub294 \uac83\uc740 \uac04\ub2e8\ud558\uae30\uc5d0 \uad73\uc774 \uad6c\ubd84\ud560 \ud544\uc694\ub294 \uc5c6\uc9c0\ub9cc, \uc774\ub7ec\ud55c \ubc29\uc2dd\uc740 \uafb8\uc900\ud788 \uc801\uc6a9\ud558\ub3c4\ub85d \uc2b5\uad00\ud654 \ud558\ub294\uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.
\uadf8\ub798\uc57c \ub098\uc911\uc5d0 \uc880 \ubcf5\uc7a1\ud55c \ub0b4\uc6a9\uc744 \ud558\ub354\ub77c\ub3c4, \uc27d\uac8c \uad6c\ubd84\ud560 \uc218 \uc788\uc73c\ub2c8\uae4c\uc694.<\/p>\n\n\n\n

\uc790 \uc774\uc81c, \uc5d1\uc140\uacfc \uc5f0\uacb0\ud558\uaca0\uc2b5\ub2c8\ub2e4.
\uc544\uae4c \ub9cc\ub4e4\uc5b4 \ub193\uc740 \ubc84\ud2bc\uc744 \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\ud558\uace0 \ub9e4\ud06c\ub85c\uc9c0\uc815\uc744 \ub204\ub985\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

VBA_Test\ub97c \uc120\ud0dd\ud558\uace0 \ud655\uc778\uc744 \ub204\ub985\ub2c8\ub2e4.<\/p>\n\n\n\n

\uadf8\ud6c4 \ubc84\ud2bc\uc744 \uc88c\ud074\ub9ad\ud558\uba74, \uc9c0\uc815\ub41c \uba85\ub839\uc774 \uc785\ub825\ub418\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\uc704\uc640 \uac19\uc774 \uc785\ub825\ub418\uace0 \uba54\uc138\uc9c0 \ucc3d\uc774 \ub728\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.(\uba54\uc138\uc9c0 \ucc3d\uc740 \ud55c\uaebc\ubc88\uc5d0 2\uac1c\uac00 \ub728\uc9c0 \uc54a\uace0, \ud655\uc778 \ubc84\ud2bc\uc744 \ub20c\ub7ec\uc57c \ub450\ubc88\uc7ac \ucc3d\uc774 \ub739\ub2c8\ub2e4.)<\/p>\n\n\n\n

\ud765\ubbf8\ub85c\uc6b0\uc2e0\uac00\uc694? ^^
\uc624\ub298\uc740 \uac04\ub2e8\ud558\uac8c \uc785\ub825\ud558\ub294 \uac83\uc744 \uc54c\ub824\ub4dc\ub838\uc2b5\ub2c8\ub2e4.
\ub2e4\uc74c\uc5d0\ub294 \uc2e4 \uc0ac\ubb34\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc54c\ub824\ub4dc\ub9ac\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc624\ub298\uc740 \uc5ec\uae30\uc11c \uc904\uc77c\uaed8\uc694. \uc990\uac70\uc6b4 \ud558\ub8e8 \ub418\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n

.Value<\/a>, <\/span>Cells<\/a>, <\/span>Excel<\/a>, <\/span>Macro<\/a>, <\/span>Msgbox<\/a>, <\/span>Range<\/a>, <\/span>VBA<\/a>, <\/span>\ub0b4\uc6a9\uc785\ub825<\/a>, <\/span>\ub9e4\ud06c\ub85c<\/a>, <\/span>\uc5d1\uc140<\/a><\/div>","protected":false},"excerpt":{"rendered":"

\uc548\ub155\ud558\uc2ed\ub2c8\uae4c \ucc44\ub791\uc774 \uc544\ube60 \ud504\ub9ac\uc544\uc785\ub2c8\ub2e4. \uc624\ub298\ub3c4 \ucde8\ubbf8\ud65c\ub3d9\uc744 \uc5d1\uc140\uc744 \uc62c\ub9b4 \uc608\uc815\uc785\ub2c8\ub2e4. \ub2e4\ub9cc, \ub108\ubb34 \uc218\uc2dd\ub9cc \ud558\ub2c8\uae4c \uc81c\uac00 \uc7ac\ubbf8\uac00 \uc5c6\uc5b4\uc9c0\ub294 \ub4ef\ud558\uc5ec VBA\ub97c \uc11e\uc5b4\uc11c \uc62c\ub9ac\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \u314e\u314e\u314e\uc6d0\ub798 \uc81c \uc804\ubb38\uc740 \uc5d1\uc140 \uc218\uc2dd\ubcf4\ub2e4\ub294 VBA \ucabd\uc774\ub77c\uace0 \ud560\uae4c\uc694 ^^;;\uc194\uc9c1\ud788 \uc804\ubb38\uae4c\uc9c0\ub294 \uc544\ub2c8\uad6c\uc694… \ub2e4\ub9cc \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1\uc744 \ub9ce\uc774 \uacf5\ubd80\ud588\ub358\ubc14 \uc788\uc5b4\uc11c, \ub2e4\ub978 \ubd84\ub4e4\ubcf4\ub2e4 \uc870\uae08 \ub354 \uae4a\uac8c \uc54c\uace0 \uc788\uc744 \uc815\ub3c4\uc785\ub2c8\ub2e4.(\uadf8\ub798\ub3c4 \uc815\ubcf4\ucc98\ub9ac\uae30\uc0ac \uc790\uaca9\uc99d\uc740 \uc788\ub2e4\uad6c\uc694… \ud558\uae34 \uacf5\uacfc\ub300\ud559\uad50 \ub098\uc628 \uc0ac\ub78c \uc911\uc5d0 \uadf8\uac70 \uc5c6\ub294 \uc0ac\ub78c\uc774 \uba87\uc774\ub098 \ub41c\ub2e4\uace0 \u3160.\u3160) \uadf8\ub798\uc11c \uc624\ub298\uc740 VBA \uc785\ubb38\uc744 \uc704\ud55c \ub9e4\ud06c\ub85c \uc5f0\uacb0 \uae30\ucd08\ub97c \uc124\uba85 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \uc77c\ub2e8 VBA\ub97c \uc124\uba85\ub4dc\ub9ac\ub824\uba74 \ub9e4\ud06c\ub85c\ub97c \uba3c\uc800 \uc124\uba85\ub4dc\ub824\uc57c \ud569\ub2c8\ub2e4.\uc5d1\uc140\uc5d0\uc11c \ub9e4\ud06c\ub85c \uae30\ub2a5\uc774\ub77c\uace0 \ud558\uba74, \uc77c\ub828\uc758 \ud589\ub3d9\uc744 \uadf8\ub300\ub85c \uae30\ub85d\ud574 \ub450\uc5c8\ub2e4\uac00,\ub098\uc911\uc5d0 \uc2e4\ud589\ud558\uba74 \ub9e4\ud06c\ub85c\uc758 \uae30\ub85d\ub41c \uc791\uc5c5\uc774 \uadf8\ub300\ub85c \ubc18\ubcf5\ud558\ub294 \ud589\uc704\ub97c \ub9d0\ud569\ub2c8\ub2e4.\uac8c\uc784\uc5d0\uc11c\ub3c4 \ub9e4\ud06c\ub85c\ub77c\ub294 \ub9d0\uc744 \uc4f0\ub294\ub370\uc694, \ub3d9\uc77c\ud558\uace0 \uac19\uc740 \uc791\uc5c5\uc744 \ubc18\ubcf5\ud558\ub294 \ud589\uc704\ub97c \ub73b\ud558\uc8e0. \ub9e4\ud06c\ub85c \uae30\ub2a5\uc740 \ubcf4\uae30 > \ub9e4\ud06c\ub85c > \ub9e4\ud06c\ub85c \uae30\ub85d\uc744 \ub204\ub974\uc2dc\uace0 \uc77c\ub828\uc758 \ud589\ub3d9\uc744 \ub9cc\ub4e4\uba74 \ub429\ub2c8\ub2e4.\uc77c\ub2e8 \uac04\ub2e8\ud558\uac8c A1\uc5d0\ub294 “\ub9e4\ud06c\ub85c \ud14c\uc2a4\ud2b8”, B1\uc5d0\ub294 “2022-11-14″\uc744 \uae30\ub85d\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.\uac04\ub2e8\ud558\uac8c \ubcf4\uae30 > \ub9e4\ud06c\ub85c > \ub9e4\ud06c\ub85c \uae30\ub85d\uc744 \ub204\ub974\uc2dc\uace0, \ub9e4\ud06c\ub85c \uc774\ub984\uc740 \ub9e4\ud06c\ub85c1\ub85c \uadf8\ub0e5 \ub450\uc2dc\uace0 \ud655\uc778\uc744 \ub204\ub974\uc138\uc694.\uadf8 \ub2e4\uc74c\uc5d0 A1\uacfc B1\uc5d0 \uc9c0\uc815\ud55c \ubb38\uad6c\ub97c \ub123\uc73c\uc2dc\uace0, \ubcf4\uae30 > \ub9e4\ud06c\ub85c > \uae30\ub85d\uc911\uc9c0\ub97c \ub204\ub974\uc138\uc694.\uadf8\ub7ec\uba74 \ud558\ub098\uc758 \ub9e4\ud06c\ub85c\uac00 \ub9cc\ub4e4\uc5b4\uc9d1\ub2c8\ub2e4. \uc790 \uadf8\ub7fc \uc774 \ub9e4\ud06c\ub85c\ub97c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub290\ub0d0… \ubc14\ub85c \ubc84\ud2bc\uc744 \ub9cc\ub4e4\uc5b4\uc11c \uc0ac\uc6a9\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.\ubc84\ud2bc\uc774\ub77c\uace0\ud574\uc11c \uac70\ucc3d\ud55c \uac83\uc740 \uc544\ub2c8\uad6c\uc694.\uc0bd\uc785 > \ub3c4\ud615\uc5d0 \ub4e4\uc5b4\uac00\uc154\uc11c \uc544\ubb34\ubaa8\uc591\uc774\ub098 \ub123\uc73c\uc2dc\uba74\ub429\ub2c8\ub2e4. \uc800\ub294 \uc0ac\uac01\ud615 : \ube57\uba74(\ubc84\ud2bc \ubaa8\uc591)\uc744 \ub123\uc744 \uac81\ub2c8\ub2e4.\uadf8\ub9ac\uace0 \ud574\ub2f9 \ub3c4\ud615\uc744 \ub9c8\uc6b0\uc2a4 \uc6b0\uce21 \ud074\ub9ad\ud558\uc2e0 \ud6c4 \ub9e4\ud06c\ub85c \uc9c0\uc815\uc744 \ub204\ub985\ub2c8\ub2e4.\uadf8\ub9ac\uace0 \uc880\uc804\uc5d0 \uae30\ub85d\ud55c \ub9e4\ud06c\ub85c1(\uc774\ub984\uc744 \ubc14\uafb8\uc168\ub2e4\uba74 \ubc14\uafb8\uc2e0 \uc774\ub984\uc744 \uc120\ud0dd\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.)\uc744 \ub204\ub974\uc2dc\uace0 \ud655\uc778 \ubc84\ud2bc\uc744 \ub20c\ub7ec\uc90d\ub2c8\ub2e4. \uc790, \uadf8\ub7fc \uc544\uae4c \ub123\uc5c8\ub358 A1\uc140\uacfc B1 \uc140\uc758 \ub0b4\uc6a9\uc744 \uc9c0\uc6b0\uc2dc\uace0, \ub9e4\ud06c\ub85c \ubc84\ud2bc\uc744 \ub20c\ub7ec\ubcf4\uc138\uc694.\ucc38\uace0\ub85c \uccab\ubc88\uc9f8 \uac12\uc740 \ud604\uc7ac \uc9c0\uc815\ub418\uc5b4 \uc788\ub294 \uc140\uc5d0 \uc785\ub825\ub420 \ud655\ub960\uc774 \ud07d\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74, \ub9e4\ud06c\ub85c \uae30\ub85d\uc740 \uc785\ub825\uce78\uc744 \uae30\uc900\uc73c\ub85c \ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c, \ub9e4\ud06c\ub85c\ub97c \uc2dc\uc791\ud560 \ub54c\uc758 \uc140(\ud604\uc7ac \uc140)\uc774 \uae30\uc900\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.\uadf8\ub798\uc11c \ub9cc\uc57d C1\uc5d0\uc11c \ub9e4\ud06c\ub85c\ub97c \uc2dc\uc791\ud55c\ub2e4\uba74, C1\uc5d0 “\ub9e4\ud06c\ub85c \ud14c\uc2a4\ud2b8”, B1\uc5d0 “2022-11-14″\ub77c\uace0 \uc785\ub825\ub420 \uac00\ub2a5\uc131\uc774 \ud07d\ub2c8\ub2e4.\ub2e4\ub9cc, \ub9e4\ud06c\ub85c \uc2dc\uc791\ud560\ub300 A1\uc774 \uc544\ub2cc \ub2e4\ub978 \uc140\uc5d0\uc11c \uc2dc\uc791\ud558\uace0 A1\uc73c\ub85c \uc62e\uaca8\uc11c “\ub9e4\ud06c\ub85c \ud14c\uc2a4\ud2b8”\ub77c\uace0 \uc4f0\uc168\uc73c\uba74, A1\uc140\uc5d0 \ub370\uc774\ud130\uac00 \uc785\ub825\ub420 \uac83\uc785\ub2c8\ub2e4. \uc800\ub294 \uc5b4\ub514\uc5d0 \ub098\uc624\ub0d0\uad6c\uc694? \uc548 \uac00\ub974\uccd0\uc8fc\uae30 \uc704\ud574\uc11c A1\uc140\uc744 \ub204\ub974\uace0 \ubc84\ud2bc\uc744 \ub204\ub97c\uaebc\uc5d0\uc694 \u314b\u314b\u314b\u314b \uc774\ub7f0\uac8c \ub9e4\ud06c\ub85c \uae30\ub2a5\uc785\ub2c8\ub2e4. \ub2e4\ub9cc, \ub9e4\ud06c\ub85c \uae30\ub2a5\uc758 \uacbd\uc6b0 \ud55c\uacc4\uac00 \uba85\ud655\ud569\ub2c8\ub2e4. \ub531 \uc9c0\uc815\ub41c \ud589\ub3d9\ub9cc \ud558\uae30 \ub54c\ubb38\uc5d0 \uc870\uac74\uc5d0 \ub530\ub978 \ub0b4\uc6a9\uc774\ub77c\ub358\uc9c0, \uc9c0\uc815\ub41c \uc0ac\uc720\uc5d0 \ub300\ud55c \uc785\ub825 \ub4f1\uc744 \ud560\uc218 \uc5c6\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.\uadf8\ub798\uc11c \ub9e4\ud06c\ub85c\uc758 \uc0c1\uc704 \uae30\ub2a5\uc73c\ub85c VBA\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. VBA\ub294 Visual Basic For Applications\uc758 \uc57d\uc790\ub85c \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1 \uc5b8\uc5b4\ub97c \uc5d1\uc140\uc5d0\ub2e4\uac00 \uc735\ud569\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc77c\uc885\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc785\ub2c8\ub2e4.\ub2e4\ub9cc, \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1 \uc5b8\uc5b4\ub294 \uacc4\uc18d \ubcc0\uacbd\ub418\ub294\ub370 \ubc18\ud574 \uc5d1\uc140\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 VBA\ub294 \ube44\uc8fc\uc5bc\ubca0\uc774\uc9c1 6.0 \ubc84\uc83c \uc218\uc900\uc5d0\uc11c \uba48\ucd94\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\uadf8 \uc810\uc740 \ucc38\uc870\ud558\uc5ec \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. \uc77c\ub2e8, \uc624\ub298\uc740 VBA\uc758 \uae30\ucd08\ub9cc \uc54c\ub824\ub4dc\ub9b4 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \uae30\ub2a5\uc758 \uc2e4\ud589\ub9cc \uc54c\ub824\ub4dc\ub9ac\uace0 \ub05d\ub0b4\uaca0\uc2b5\ub2c8\ub2e4.\ud2c8\ud2c8\uc774 \uc0ac\uc6a9\ud560\ub9cc\ud55c \uc218\uc2dd\ub4e4 \uc54c\ub824\ub4dc\ub9b4\uaed8\uc694. ^^\uc544\ub2c8\uba74 \uc800\ud55c\ud14c \uac1c\uc778\uc801\uc73c\ub85c \uc9c8\ubb38\ud574 \uc8fc\uc2dc\uba74 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.(\ud648\ud398\uc774\uc9c0 \uc624\ub978\ucabd \uc544\ub798\uc5d0 \ubcf4\uc2dc\uba74 \uad00\ub9ac\uc790 \ubb38\uc758\ub77c\uace0 \uac8c\uc2dc\ud310\uc774 \uc5f0\uacb0\ub418\uc5b4 \uc788\uc5b4\uc694. \uc5d1\uc140\ubb38\uc758\ub77c\uace0 \uc368 \uc8fc\uc2dc\uba74 \uc81c\uac00 \uc54c\uace0 \uc788\ub2e4\uba74 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.) \uc790 \uc624\ub298\uc740 A1\uc140\uc5d0 “VBA \ud14c\uc2a4\ud2b8”, B1\uc140\uc5d0 “2022-11-14″\uc744 \uc785\ub825\ud558\uace0, \uba54\uc138\uc9c0 \ubc15\uc2a4\ub97c \ub744\uc6cc “Welcome to VBA World”\ub97c \uc368 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\uc6f0\ucef4 \ubb38\uad6c\ub294 \ubaa8\ub4e0 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub97c \ubc30\uc6b8\ub54c \ucd5c\ucd08\ub85c \ubc30\uc6b0\ub294 \ubb38\uad6c \uc2dd\uc774\uc5d0\uc694 \u314e\u314e\u314e. \uadf8\ub798\uc11c \uc800\ub3c4 \uadf8\ub798\uc694(\uacf5\ub3cc\uc774\uc758 \ubcf8\ub2a5\uc785\ub2c8\ub2e4.) \uc77c\ub2e8 \uc5d1\uc140\uc5d0\uc11c Alt + F11\uc744 \ub20c\ub7ec\uc8fc\uc2dc\uba74 Microsoft Visual Basic for Applications – \ud1b5\ud569 \ubb38\uc11c1\uc774\ub77c\ub294 \ucc3d\uc774 \uc5f4\ub9ac\ub294 \uac78 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc67c\ucabd\uc5d0 \ud504\ub85c\uc81d\ud2b8\ub77c\ub294 \ucc3d\uc5d0\ub294 \ud604\uc7ac \uc5f4\ub824\uc788\ub294 \ubaa8\ub4e0 \uc5d1\uc140 \ubb38\uc11c\ub4e4\uc774 \ub2e4 \ub098\ud0c0\ub098\uc694. \uadf8\uc911 VBA\ub97c \uc801\uc6a9\ud560 \ubb38\uc11c\ub97c \uc120\ud0dd\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.(\uc790\ub3d9\uc73c\ub85c \uc120\ud0dd\ub418\uc5b4 \uc788\uc5b4\uc694.)\uc800\uae30\uc11c \ubaa8\ub4c8\uc774\ub77c\ub294 \ud3f4\ub354 \uc606\uc5d0 +\ub97c \ub204\ub974\uc2dc\uba74 Module 1\uc774\ub77c\ub294 \uac8c \ubcf4\uc77c\uac83\uc785\ub2c8\ub2e4. \uadf8\uac78 \ub354\ube14\ud074\ub9ad\ud558\uc2dc\uba74, \uc544\uae4c \uc2e4\ud589\ud55c \ub9e4\ud06c\ub85c1\uc758 \uc218\uc2dd\uc774 \ub098\ud0c0\ub0a0 \uac70\uc5d0\uc694. \uc800 \uc218\uc2dd\uc774 \ub9e4\ud06c\ub85c1\uc5d0 \uc800\uc7a5\ub41c \uc218\uc2dd\uc785\ub2c8\ub2e4.\uc124\uba85\ud574 \ub4dc\ub9b4 \uc218\ub294 \uc788\uc73c\ub098, \ub098\uc911\uc5d0 \ud558\ub098\uc529 \uc54c\ub824\ub4dc\ub9ac\ub2e4 \ubcf4\uba74 \uc124\uba85\ub4dc\ub824\uc57c \ud558\ub294 \ub0b4\uc6a9\uc774\ub77c\uc11c, \uc624\ub298\uc740 \uadf8\ub0e5 \ud328\uc2a4\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc790 End Sub \ubc11\uc5d0 \uc5d4\ud130\ud0a4\ub97c \ub20c\ub7ec \uacf5\ubc31\uc744 \ub298\ub824\uc8fc\uc2dc\uad6c\uc694.Sub VBA_Test()\ub77c\uace0 \uc785\ub825\ud558\uace0 \uc5d4\ud130\ud0a4\ub97c \ub20c\ub7ec\uc8fc\uc138\uc694. \uadf8\ub7ec\uba74 \uc774\uc804 End Sub \ubc11\uc5d0 \uc904\uc774 \ub098\ud0c0\ub098\uace0, \uc0c8\ub85c\uc6b4 End Sub\uac00 \ub098\ud0c0\ub098\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.Sub\ub294 \ud558\uc704 \uba85\ub839\uc5b4\ub97c \uc2dc\uc791\ud55c\ub2e4\ub294 \uba85\ub839\uc774\uba70, End Sub\ub294 \ud574\ub2f9 \uba85\ub839\uc774 \ub05d\ub0ac\uc74c\uc744 \uc54c\ub9ac\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.\uc989 Sub\uc640 End Sub \uc0ac\uc774\uc758 \ub0b4\uc6a9\uc774 VBA \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\ub294 \uad6c\ubb38\uc774 \ub418\uaca0\uc2b5\ub2c8\ub2e4. A1\uc140\uacfc B1\uc140\uc5d0 \ub0b4\uc6a9\uc744 \uc785\ub825\ud558\ub294 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. Range(“A1”).Value = “VBA \ud14c\uc2a4\ud2b8”Range(“B1”).Value = “2022-11-14” Range()\ub294 \ubc94\uc704\ub97c \uc120\ud0dd\ud558\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4.“A1” \ucc98\ub7fc \ud558\ub098\uc758 \uc140\uc744 \uc9c0\uc815\ud560\uc218\ub3c4 \uc788\uc9c0\ub9cc, “A1:A10″\ucc98\ub7fc \ubc94\uc704\ub97c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\uadf8\ub9ac\uace0 \ub4a4\uc5d0 \uc788\ub294 .Value\ub294 \uc785\ub825\ub41c \uac12\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.Range()\ub4a4\uc5d0 \uc810\uc744 \ucc0d\uc73c\uba74 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uba85\ub839\uc5b4\uac00 \uc5ec\ub7ec\uac1c \ub098\uc624\uac8c\ub429\ub2c8\ub2e4.\uc774\uc911\uc5d0\uc11c .Value\ub294 \ud574\ub2f9 \ubc94\uc774\uc5d0 \ub4e4\uc5b4\uac00\ub294 \ub0b4\uc6a9\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.(\ub098\uc911\uc5d0 \uc124\uba85\ud558\uaca0\uc9c0\ub9cc, \ubcf5\uc0ac\ub3c4 \ud560 \uc218 \uc788\uace0, \uc140 \uc11c\uc2dd\uc744 \ubc14\uafc0 \uc218\ub3c4 \uc788\uace0, \ubc94\uc704 \uc9c0\uc815\uc5d0\uc11c \ud560 \uc218 \uc788\ub294 \uc5ec\ub7ec\uac00\uc9c0 \uae30\ub2a5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.) \ub610\ud55c, Cells \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.Cells\uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \ub54c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud574\uc57c \ud569\ub2c8\ub2e4. Cells(1,1).Value = “VBA \ud14c\uc2a4\ud2b8”Cells(1,2).Value = “2022-11-14” Cells\uc758 \uba85\ub839\uc5b4 \ub4a4\uc5d0 \uc22b\uc790\ub294 \ubc18\ub4dc\uc2dc \ud589\uc774 \uba3c\uc800\uc774\uace0, \uc5f4\uc774 \ub098\uc911\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.\uc989, A1\uc140\uc740 (1,1)\uc774\uc9c0\ub9cc, B1\uc740 (1,2)\uc785\ub2c8\ub2e4. – 1\ud589 1\uc5f4(A\uc5f4), 1\ud589 2\uc5f4(B\uc5f4)\uc784 \uacb0\uacfc\ub294 \ub3d9\uc77c\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uba54\uc138\uc9c0 \ubc15\uc2a4\ub97c \ub744\uc6b0\ub294 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. msgbox “Welcome to VBA World” msgbox \ub4a4\uc5d0 \ub530\uc634\ud45c\ub97c \ub123\uc5b4\uc11c \uae00\uc790\ub97c \uc785\ub825\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \ud615\ud0dc\uc785\ub2c8\ub2e4.\uc774 \uc678\uc5d0\ub3c4 \uc704\uc5d0\uc11c \uc0ac\uc6a9\ud55c Range()\ub098, Cells()\ub97c \uc0ac\uc6a9\ud558\uc5ec \uba54\uc138\uc9c0 \ubc15\uc2a4\ub97c \ub744\uc6b8\uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\uc608\ub97c \ub4e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. msgbox Range(“A1”).Value \ucc38 \uc27d\uc8e0? \u314e\u314e\u314e\u314e \uc774\uac70 \ud574\ubcf4\uace0 \uc2f6\uc5c8\uc5b4\uc694. \uc608\uc804\uc5d0 \ubc25\ub85c\uc2a4 \uc544\uc800\uc528 \ubcf4\uba74\uc11c \u314b\u314b\u314b\u314b\uc77c\ub2e8 \uc704\uc5d0 \ub0b4\uc6a9\uc744 \ubaa8\ub450 \ud3ec\ud568\ud558\uc5ec \uc81c\uac00 \ub9cc\ub4e0 VBA \uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ubcf4\uc2dc\uba74 Sub \ubc11\uc5d0 \uc2dc\uc791\ud560\ub54c \ud0ed\uc73c\ub85c \ud55c\uce78 \uc548\uc73c\ub85c \ub4e4\uc5b4\uac04 \uac83\uc744 \ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.Sub \uc548\uc5d0 \uc788\ub294 \uba85\ub839\uc5b4\ub97c \uad6c\ubd84\ud558\uae30 \uc704\ud558\uc5ec \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4.\uc624\ub298 \ud558\ub294 \uac83\uc740 \uac04\ub2e8\ud558\uae30\uc5d0 \uad73\uc774 \uad6c\ubd84\ud560 \ud544\uc694\ub294 \uc5c6\uc9c0\ub9cc, \uc774\ub7ec\ud55c \ubc29\uc2dd\uc740 \uafb8\uc900\ud788 \uc801\uc6a9\ud558\ub3c4\ub85d \uc2b5\uad00\ud654 \ud558\ub294\uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.\uadf8\ub798\uc57c \ub098\uc911\uc5d0 \uc880 \ubcf5\uc7a1\ud55c \ub0b4\uc6a9\uc744 \ud558\ub354\ub77c\ub3c4, \uc27d\uac8c \uad6c\ubd84\ud560 \uc218 \uc788\uc73c\ub2c8\uae4c\uc694. \uc790 \uc774\uc81c, \uc5d1\uc140\uacfc \uc5f0\uacb0\ud558\uaca0\uc2b5\ub2c8\ub2e4.\uc544\uae4c \ub9cc\ub4e4\uc5b4 \ub193\uc740 \ubc84\ud2bc\uc744 \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\ud558\uace0 \ub9e4\ud06c\ub85c\uc9c0\uc815\uc744 \ub204\ub985\ub2c8\ub2e4. VBA_Test\ub97c \uc120\ud0dd\ud558\uace0 \ud655\uc778\uc744 \ub204\ub985\ub2c8\ub2e4. \uadf8\ud6c4 \ubc84\ud2bc\uc744 \uc88c\ud074\ub9ad\ud558\uba74, \uc9c0\uc815\ub41c \uba85\ub839\uc774 \uc785\ub825\ub418\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc704\uc640 \uac19\uc774 \uc785\ub825\ub418\uace0 \uba54\uc138\uc9c0 \ucc3d\uc774 \ub728\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.(\uba54\uc138\uc9c0 \ucc3d\uc740 \ud55c\uaebc\ubc88\uc5d0 2\uac1c\uac00 \ub728\uc9c0 \uc54a\uace0, \ud655\uc778 \ubc84\ud2bc\uc744 \ub20c\ub7ec\uc57c \ub450\ubc88\uc7ac \ucc3d\uc774 \ub739\ub2c8\ub2e4.) \ud765\ubbf8\ub85c\uc6b0\uc2e0\uac00\uc694? ^^\uc624\ub298\uc740 \uac04\ub2e8\ud558\uac8c \uc785\ub825\ud558\ub294 \uac83\uc744 \uc54c\ub824\ub4dc\ub838\uc2b5\ub2c8\ub2e4.\ub2e4\uc74c\uc5d0\ub294 \uc2e4 \uc0ac\ubb34\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc54c\ub824\ub4dc\ub9ac\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc624\ub298\uc740 \uc5ec\uae30\uc11c \uc904\uc77c\uaed8\uc694. \uc990\uac70\uc6b4 \ud558\ub8e8 \ub418\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":723,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[27],"tags":[182,181,142,179,183,180,177,184,178,141],"class_list":["post-717","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-27","tag-value","tag-cells","tag-excel-2","tag-macro","tag-msgbox","tag-range","tag-vba","tag-184","tag-178","tag-141"],"_links":{"self":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=717"}],"version-history":[{"count":1,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/717\/revisions"}],"predecessor-version":[{"id":728,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/posts\/717\/revisions\/728"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=\/wp\/v2\/media\/723"}],"wp:attachment":[{"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaerang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}