¿¢¼¿ VBA 2013 [½Ç¹«]
¿¢¼¿ VBA 2013 [½Ç¹«] °ÀÇ´Â ¾ËÁö¿À R&D ¿¬±¸¼¾ÅÍ¿¡¼ Á÷Á¢ °³¹ßµÈ °ÀÇ·Î ¿¢¼¿ VBA¿¡ ´ëÇØ¼ ±âº»ÄÚµåÀÇ ÀÌÇØºÎÅÍ ½Ç¹« ÇÁ·Î±×·¡¹Ö±îÁö ÃÑÁ¤¸®µÇ¾úÀ¸¸ç, ½Ç¹«¿¡¼ ¹Ù·Î Ȱ¿ëÇÒ ¼ö ÀÖ´Â ½Ç½À ¿¹Á¦¸¦ ÅëÇØ º¸´Ù ¿Ïº®ÇÏ°Ô ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
-
01.24ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 1
VBA, ¸ÅÅ©·Î, ÇÁ·Î½ÃÀúÀÇ °³³ä°ú VBA ȸ鱸¼º¿¡ ´ëÇØ ¾Ë¾Æº¸°í, ¹Ýº¹¹®À» Ȱ¿ëÇÑ ½Ç½ÀÀ» ÁøÇàÇÕ´Ï´Ù
Ã¥°¥ÇÇ : [00:00] VBA, ¸ÅÅ©·Î °³³ä/[04:38] vbe È£Ãâ¹æ¹ý/[10:10] ¸ÅÅ©·Î »ý¼º/[14:22] µ¥ÀÌÅÍÀÔ·Â(celldata)/[19:30] ÇÔ¼ö ÇÁ·Î½ÃÀú¿Í ÀÏ¹Ý ÇÁ·Î½ÃÀú
-
02.1½Ã°£ 2ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 2
msgbox, inputbox»ç¿ëÇü½Ä°ú º¯¼öÀÇ Á¾·ù µîÀ» °øºÎÇϰí Á÷Á¢ ÀÛ¼º¡¤¼±¾ðÇÏ¿© ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] ¼Ó¼º(property)/[03:35] ¹Ýº¹¹®/[05:30] ¸Þ¼µå(method)/[07:35] ¼¿¿¡ »ö ÀÔ·Â, Á¦°Å/[12:05] vba ÀÎÅÍÆäÀ̽º/[14:12] ¼½Ä Á¦°Å/[19:42] msgbox (ÀϹÝÇü½Ä, º¯¼öÇü½Ä)/[22:28] msgbox ³»Àå»ó¼ö/[25:05] inputbox (ÀϹÝÇü½Ä, º¯¼öÇü½Ä)/[28:22] º¯¼ö/[36:28] Á¶°Ç¹®(IF¹®)/[45:52] inputbox/[48:38] ¿¹Á¦ ½Ç½À(¼öÁÖ ÇöȲ)
-
03.42ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 3
ºÐ±â¹®, Áß´ÜÁ¡, range°³Ã¼ ÄÚµù, goto¹®, call¹®, ½ÃÆ®À̵¿, ½ÃÆ®À̸§È®ÀÎ µîÀ» ½Ç½ÀÇØ º¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] VBA ÇÊ¿ä¿ë¾î/[01:03] °³Ã¼(object)/[04:29] È£Ãâ¹®(call¹®)/[06:38] ³»ÀåÇÔ¼ö È£Ãâ(¸Þ¸ðÀå)/[10:40] ºÐ±â¹®(goto¹®)/[15:55] ºÐ±â¹®(ongoto¹®)/[16:40] Àüü ½ÇÇà, ÇѴܰ辿 ½ÇÇà, Áß´ÜÁ¡/[20:47] ½ÃÆ® ÅëÁ¦(½ÃÆ®¸í ³ªÅ¸³»±â, ½ÃÆ® À̵¿, ½ÃÆ® À̸§¹Ù²Ù±â, ½ÃÆ® Ãß°¡)/[35:43] ¿¹Á¦ ½Ç½À(°Å·¡¸í¼¼Ç¥)
-
04.38ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 4
º¯È¯ÇÔ¼ö Á¶°Ç¹®, ÄÞº¸»óÀÚ, select~case ¹®, if~then¹®, º¯¼ö Á¤ÀÇ º¸±â
Ã¥°¥ÇÇ : [00:00] º¯È¯ÇÔ¼ö/[04:01] º¯È¯ÇÔ¼ö ½Ç½À/[11:35] º¯¼öÁ¤ÀǺ¸±â/[12:52] If~Then ¹®/[17:12] select~case ¹®/[19:05] activeX ÄÁÆ®·ÑÀÇ ÄÞº¸»óÀÚ/[23:04] ÄÞº¸¹Ú½º »ý¼º/[28:35] ¿¹Á¦ ½Ç½À(°Å·¡¸í¼¼Ç¥)
-
05.40ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 5
º¯¼ö, ¹è¿º¯¼ö, ÄÄÇ»ÅÍÀÇ ¸¸´É °ø½Ä, for~next ¹®, option base ¼ýÀÚ¹® µîÀ» ¾Ë¾Æº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:06] º¯¼ö¿Í ¹è¿º¯¼ö/[05:42] ÄÄÇ»ÅÍÀÇ ¸¸´É°ø½Ä/[08:27] Option Base ¼ýÀÚ¹®/[12:15] ¹Ýº¹¹®(For~Next ¹®)/[22:12] with ¹®/[27:10] Áßø with ¹®/[29:55] ¿¹Á¦ ½Ç½À(±Þ¿©´ëÀå, ±Þ¿©¸í¼¼¼)
-
06.41ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 6
Do~Loop ¹®, For Each In~Next ¹® ¼±Á¶°Ç°Ë»ç, ÈÄÁ¶°Ç°Ë»ç¸¦ ÀÌÇØÇÕ´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] Do~Loop ¹®/[00:32] ¼±Á¶°Ç°Ë»ç(ChkFirstWhile)/[04:37] ÈÄÁ¶°Ç°Ë»ç(ChkLastWhile)/[06:28] ¼±Á¶°Ç°Ë»ç(ChkFirstUntil)/[08:31] ÈÄÁ¶°Ç°Ë»ç(ChkLastUntil)/[09:45] Exit do/[15:20] For Each In~next ¹®/[19:29] ¼¿ »ö»ó ÀÔ·Â, Á¦°Å/[23:53] ¿¹Á¦ ½Ç½À(°Å·¡¾÷ü)
-
07.34ºÐ [°³³ä¿Ï¼º] Çѹ濡 ³¡³»´Â ¿¢¼¿ VBA ½Ç¹«°úÁ¤! - Chapter 7
¿À·ùó¸®, ȸ麯°æ¹æÁö, ½ÃÆ®ÆÄÀÏÀúÀå, on errer goto line, on error resume next, onerror goto0, ActiveWorkbook°³Ã¼, ȸ麯°æµÇÁö ¾Êµµ·Ï ¼³Á¤Çغ¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] on error goto/[04:22] on error resume next/[09:10] err.clear/[11:15] err.description/[13:00] on error goto 0/[14:04] ÁٹٲÞ(_, vblf, chr)/[16:51] Ȱ¼º¹®¼ ÀúÀå
-
08.40ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 1
useform »ç¿ë, ¸ð´ÞÆû, Application. On Time ¸Þ¼µå, ½Ã°£°ü·Ã ³»ÀåÇÔ¼ö, FormatÇü½Ä, form.show, event¸¦ ¾Ë¾Æº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] On Time ¸Þ¼µå/[00:51] format ÇÔ¼ö/[05:13] »ç¿ëÀÚ Á¤ÀÇ Çü½Ä/[16:34] ¸í·É´ÜÃß »ý¼º, ÄÚµå ÀÛ¼º/[18:12] ÀÛ¾÷½ÃÀ۽ð£, ÀÛ¾÷Á¾·á½Ã°£, ÀÛ¾÷½Ã°£/[21:29] UserForm ÀÛ¼º/[24:40] »ç¿ëÀÚÆû ³ªÅ¸³»±â, ´Ý±â/[27:33] ¸ð´Þ°ú ¸ð´Þ¸®½º/[33:30] ŸÀÌ¸Ó ½ÃÀÛ, Á¾·á/[37:03] Æû ÃʱâÈ, Æû Á¾·á
-
09.30ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 2
label¼Ó¼º, textbox¼Ó¼º, OptionButtont¼Ó¼º¿¡ ´ëÇØ °øºÎÇÏ°í ½Ç½ÀÇØº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] ¼Ó¼º°ú ÄÚµùâÀÇ Â÷ÀÌ/[00:21] lable ¼Ó¼º/[04:54] ÄÞº¸¹Ú½º ±â´É Ãß°¡/[11:20] CurrenRegion ¼Ó¼º/[21:18] ÅØ½ºÆ® ¹Ú½º/[23:58] ¿¹Á¦ ½Ç½À(µ¥ÀÌÅÍ ÇÕ°è Ç¥½Ã)
-
10.25ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 3
flowÂ÷Æ®, ¹Ýº¹¹®, À̸§Á¤ÀÇ, ¼ø¼µµÁ¦ÀÛÀ» ½Ç½ÀÇØ º¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] ¼ø¼µµ Á¦ÀÛ/[04:10] ¿¹Á¦ ½Ç½À(°Ë»ö ¿Ï·á)/[08:17] ¼ø¼µµ Åä±Û ¹öư ±¸Çö/[11:37] search ¹öư ±¸Çö/[18:52] ¸ðµâ°ú ¸ÅÅ©·Î ¿¬°á
-
11.23ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 4
RGBÇÔ¼ö, GotFocus, MouseÀ̺¥Æ®, application.caller ¿¡ ´ëÇØ °øºÎÇÏ°í ½Ç½ÀÇØº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:21] º¯¼ö ¼±¾ð(ÀϹÝÀûÀÎ ÇüÅÂ, Á¤ÀûÀÎ ÇüÅÂ)/[02:11] ÇÔ¼ö ¸¸µé±â/[04:30] RGB ÇÔ¼öÀÇ »ö»ó/[07:59] GetFocus, LostFocus/[10:17] ¸¶¿ì½º À̺¥Æ®(Mouse down, Mouse up, MouseMove)/[15:19] Application.Caller/[17:51] ¿¹Á¦ ½Ç½À(Application.Caller1)/[19:52] ¿¹Á¦ ½Ç½À(Application.Caller2)
-
12.22ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 5
Àμö³Ñ°ÜÁÖ´Â ÇÁ·Î½ÃÀú, isemptyÇÔ¼ö, °íÀ¯Ç׸ñÃàÃâÇÊÅÍ¿¡ ´ëÇØ °øºÎÇÕ´Ï´Ù.
Ã¥°¥ÇÇ : [00:07] Àμö¸¦ ³Ñ°ÜÁÖ´Â ÇÁ·Î½ÃÀú/[04:25] °íÀ¯ Ç׸ñ ÃßÃâ/[05:14] ¸ÅÅ©·Î¸¦ ÀÌ¿ëÇÑ ¸ðµâ »ý¼º/[09:39] ¼ø¼µµ/[14:45] ¸ðµâ°ú ¸ÅÅ©·Î ¿¬°á/[16:23] ½ÃÆ® Á¦°Å(delSheet)/[17:48] ½ÃÆ® »ý¼º(MakeCompanySheet)/[19:02] ÇÁ·Î½ÃÀú È£Ãâ
-
13.27ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 6
Range.PasteSpecial ¸Þ¼µå, linkºÙ¿©³Ö±â, picturesºÙ¿©³Ö±â, Intersect¸Þ¼µå, Union ¸Þ¼µå
Ã¥°¥ÇÇ : [00:00] PasteSpecial ¸Þ¼µå /[05:07] ¿¬»êÀÚ ÇüÅ ºÙ¿©³Ö±â(operation)/[06:33] ¿¬°áÇÏ¿© ºÙ¿©³Ö±â(Link)/[08:31] ±×¸²À¸·Î ºÙ¿©³Ö±â(pictures)/[09:25] ¿¹Á¦ ½Ç½À(ºÙ¿©³Ö±â)/[13:33] ÇÕÁýÇÕ(Union)/[15:44] ¿¹Á¦ ½Ç½À(±³Åëºñ ¸í¼¼¼)/[22:23] ½Ç½À ¿¡Á¦(ÆÇ¸Å ÇöȲ)
-
14.29ºÐ º¹ÀâÇÑ ¾÷¹«°úÁ¤À» ºü¸£°Ô Ŭ¸®¾î ÇÒ ¼ö ÀÖ´Â VBA - Chapter 7
for each º¯¼ö in Ä÷º¼Ç ~ nextº¯¼ö, rand ÇÔ¼ö, offset ¼Ó¼º¿¡ ´ëÇØ °øºÎÇØº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] range °³Ã¼¸¦ ÀÌ¿ëÇÑ À̸§/[05:34] For Each ~next ¹®/[10:29] offset ¼Ó¼º/[13:35] ¿¹Á¦ ½Ç½À(ÁÖ¼Ò·Ï)/[18:20] º¯¼ö ¼±¾ð/[22:01] offset/[24:46] º¹»ç¸ðµå ÇØÁ¦(CutCopyMode)/[27:13] ¸ðµâ°ú ¸ÅÅ©·Î ¿¬°á
-
15.34ºÐ VBA ¸¶¹«¸® ÆÄÀ̳ΠƯ° - Chapter 1
range.SpecialCells(Type[Value]), Lbound¿Í UboundÇÔ¼ö¿¡ ´ëÇØ ¾Ë¾Æº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] SpecialCells ¸Þ¼µå/[06:42] Lbound¿Í Ubound ÇÔ¼ö/[12:35] ÄÞº¸¹Ú½º »ý¼º(Dropdown)/[17:05] À¯´ÏÅ©ÇÑ ÄÞº¸¹Ú½º »ý¼º/[20:12] ¿¹Á¦ ½Ç½À(ÁÖ¼Ò·Ï)/[25:18] ÇÊÅÍ, »èÁ¦/[30:11] ¸ðµâ°ú ¸ÅÅ©·Î ¿¬°á
-
16.29ºÐ VBA ¸¶¹«¸® ÆÄÀ̳ΠƯ° - Chapter 2
Application.Onkey¸Þ¼µå,Range.EntireRow¼Ó¼º,Application.Speech¼Ó¼º¿¡ ´ëÇØ ¾Ë¾Æº¾´Ï´Ù.
Ã¥°¥ÇÇ : [00:09] OnKey/[03:30] ÇÁ·Î½ÃÀú Ű ÇÒ´ç/[05:55] EntireRow ¼Ó¼º/[13:40] Speech.Speak ¸Þ¼µå/[20:31] ¿¹Á¦ ½Ç½À(¹ÝǰºÐ¼®)
-
17.30ºÐ VBA ¸¶¹«¸® ÆÄÀ̳ΠƯ° - Chapter 3
GetopenFilename, Insert¸Þ¼µå¿Í shape.Onaction, application.caller¼Ó¼º¿¡ ´ëÇØ °øºÎÇÏ°í ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] GetopenFilename ¸Þ¼µå/[02:23] pictures.Insert ¸Þ¼µå/[04:09] shape.OnAction ¼Ó¼º/[06:38] application.caller ¼Ó¼º/[08:35] Ä«¸Þ¶ó ±â´É/[13:33] À̹ÌÁö È®´ë, Ãà¼Ò/[16:58] ¿¹Á¦ ½Ç½À(Á¦Ç°Á¤º¸)
-
18.23ºÐ VBA ¸¶¹«¸® ÆÄÀ̳ΠƯ° - Chapter 4
TrimÇÔ¼ö, Range.Replace ¸Þ¼µå, Change À̺¥Æ®, Application.InputBox ¸Þ¼µå, ToggleButton ÄÁÆ®·Ñ¿¡ ´ëÇØ °øºÎÇÏ°í ½Ç½ÀÇÕ´Ï´Ù.
Ã¥°¥ÇÇ : [00:00] Trim ÇÔ¼ö(LTrim, RTrim)/[05:16] Application.InputBox ¸Þ¼µå/[06:52] Åä±Û ´ÜÃß(ToggleButton)/[07:50] Change À̺¥Æ®/[15:57] ¿¹Á¦ ½Ç½À(ÆÇ¸ÅÇöȲ)/[19:45] ¿¹Á¦ ½Ç½À(ÁöÁ¡º° ÀÔ°íÇöȲ)
-
19.1½Ã°£ 4ºÐ VBA ¸¶¹«¸® ÆÄÀ̳ΠƯ° - Chapter 5
ÆûÀ» ÀÌ¿ëÇÑ ÀԷ¼³°è, °Ë»ö±¸Çö ¼³°è(Åä±Û¹öưÀ¸·Î ºÐ¼®¸ðµå ¼³Á¤ ¹× °Ë»ö ¿É¼Çµé ³ªÅ¸³»±â ¹× ¼û±â±â,ÀÚµ¿ÇÊÅͰ˻ö µî), »ç¿ëÀÚÆûÀÇ MultiPage µµ±¸Á¦ÀÛÇϱâ, ¸ÖƼÆäÀÌÁö°£ À̵¿°ú Æûµ¥ÀÌÅÍ ½ÃÆ®·Î Àü¼Û
Ã¥°¥ÇÇ : [00:00] ÇÁ·Î¼¼¼ ¼¼¿ì±â/[01:18] ÀϹÝȸé/[03:00] ÀÔ·Âȸé(»ç¿ëÀÚÆû)/[03:33] °Ë»ö(ÇÊÅÍ)¿É¼Ç/[06:09] Æû¿¡¼ ½ÃÆ®·Î µ¥ÀÌÅÍ Àü¼Û/[20:26] ºÐ¼®¸ðµå ¼³Á¤¹öư/[26:35] ÀÚµ¿ ÇÊÅÍ ¼³Á¤/[33:06] ¸ÖƼÆäÀÌÁö¸¦ ÀÌ¿ëÇÑ ¸¶¹ý»ç »ç¿ë/[35:12] È¸é ¼³°è(ÀϹÝȸé, »ç¿ëÀÚÆû)/[39:38] ´ÙÁ߯äÀÌÁöÆû È£Ãâ/[44:47] »ç¿ëÀÚÆû »ý¼º/[50:15] Ãë¼Ò ¹öư »ý¼º/[52:06] ½ÃÆ®·Î µ¥ÀÌÅÍ Àü¼Û
-
20.1½Ã°£ 16ºÐ VBA ¸¶¹«¸® ÆÄÀ̳ΠƯ° - Chapter 6
´Þ·Â ¸¸µé±â, ÀÏÁ¤Ç¥ ¸¸µé±â, Á¦Ç°Ä«´Þ·Î±× ¸¸µé±â
Ã¥°¥ÇÇ : [00:00] ´Þ·Â ¸¸µé±â/[00:10] Á¦ÀÛÇÁ·Î¼¼¼ È®ÀÎ/[02:03] set ¹®/[03:41] ¾ç½ÄÀÇ ÄÞº¸»óÀÚ »ç¿ë/[08:38] date, year, month ÇÔ¼ö/[09:40] ÄÞº¸»óÀÚ¿¡¼ ¼±ÅÃÇÑ ¸®½ºÆ® ³ªÅ¸³»±â/[12:11] µ¥ÀÌÅÍ »èÁ¦(clearcontents)/[13:24] ¿øÇÏ´Â ³¯Â¥ ¾Ë¾Æ³»±â(dateserial)/[14:12] µ¥ÀÌÅÍ »Ñ¸®±â(offset)/[16:55] ³¯Â¥ Ç¥½Ã ÄÞº¸»óÀÚ/[25:05] ¸ðµâ°ú ¸ÅÅ©·Î ¿¬°á/[25:49] Á¶°ÇºÎ¼½Ä ÀÛ¼º/[27:10] ÀÏÁ¤Ç¥ ¸¸µé±â/[27:22] Á¦ÀÛÇÁ·Î¼¼¼ È®ÀÎ/[28:55] Application.InputBox ¸Þ¼µå/[32:57] With ~ end With¹®/[35:27] Shapes.AddLine ¸Þ¼µå/[44:48] line.forecolor.RGB ¼Ó¼º/[45:30] Worksheet.ScrollArea ¼Ó¼º/[48;07] EnableSelection ¼Ó¼º/[50:50] È»ìÇ¥ ±×¸®±â/[53:45] ¸ÅÅ©·Î ÁöÁ¤/[55:38] Á¦Ç° īŻ·Î±× ¸¸µé±â/[56:12] 1¾¿ °¨¼Ò, 1¾¿ Áõ°¡ÇÏ´Â ÄÚµù/[1:02:23] ActiveSheet,Pictures.Insert ¸Þ¼µå/[01:10:22] ¿¹Á¦ ½Ç½À(Á¦Ç°Á¦¿ø)