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