|
|
|
VBA ÀÔ¹®°ÁÂ
VBAÀÇ ±âÃʺÎÅÍ Â÷±ÙÂ÷±Ù ¼³¸íÇØ ´Þ¶ó´Â ¸¹Àº ºÐµéÀÇ ¿äû¿¡ ÀÇÇØ VBA
ÀÔ¹®°Á¸¦ ½ÃÀÛÇÕ´Ï´Ù.
VBAÀÇ ±âÃÊ ¹× ÇÁ·Î±×·¡¹ÖÀÇ ±âº» °³³äÀ» Á¤¸³ÇϽôµ¥ ÀÛÀ¸³ª¸¶ µµ¿òÀÌ
µÇ¾úÀ¸¸é ÁÁ°Ú½À´Ï´Ù. |
|
|
|
|
|
 |
VBA¸¦ ¹è¿ì±â À§ÇÑ Çʼö ±âÃÊÁö½Ä
ÀÐÀ½¼ö |
|
|
|
|
|
|
|
[2002-11-19] 1. Introducing VBA (Visual Basic for Application) |
|
187,006 |
|
|
|
|
[2002-11-29] 2. ¾ÖÇø®ÄÉÀ̼Ç, ¿ÀºêÁ§Æ®, ÇÁ·ÎÆÛƼ ±×¸®°í ¸Þ¼µå |
|
99,712
|
|
|
|
|
[2002-12-20] 3.
¿öÅ©ºÏ ¿ÀºêÁ§Æ® |
|
77,581
|
|
|
|
|
[2003-04-25]
4. ¿öÅ©½ÃÆ® ¿ÀºêÁ§Æ® |
|
71,696
|
|
|
|
|
5. ·¹ÀÎÁö ¿ÀºêÁ§Æ®¸¦ »ý¼ºÇÏ´Â ¸î °¡Áö ¹æ¹ý |
|
|
|
|
|
|
[2004-04-10]
5.1 Range, Cells ¼Ó¼º |
|
93,055
|
|
|
|
|
[2004-05-18]
5.2 Rows, Columns, EntireRow, EntireColumn ¼Ó¼º |
|
64,155
|
|
|
|
|
[2004-12-10]
5.3 CurrentRegion, UsedRange ¼Ó¼º |
|
49,840
|
|
|
|
|
[2004-12-14]
5.4 Union,
Intersect ¸Þ¼µå |
|
44,562
|
|
|
|
|
[2004-12-28]
5.5 SpecialCells, End ¼Ó¼º |
|
45,241
|
|
|
|
|
[2005-03-21] 6.
Sub ÇÁ·Î½ÃÀú¿Í Function ÇÁ·Î½ÃÀú |
|
51,572
|
|
|
|
|
|
|
|
|
 |
Excel
2007ÀÇ ¸®º»
Ä¿½ºÅ͸¶ÀÌ¡ |
|
|
|
|
|
|
|
[2008-05-11] 1. ÅÇ(Tab)¿¡ ±×·ì Ãß°¡Çϱâ |
|
18,811 |
|
|
|
|
[2008-05-19] 2. ¸®º»¿¡ »õ·Î¿î ÅÇ Ãß°¡Çϱâ |
|
13,126 |
|
|
|
|
[2008-05-27] 3. ¿¢¼¿ 2007¿¡¼ µµ±¸ ¸ðÀ½ Èä³»³»±â |
|
12,511 |
|
|
|
|
4. RibbonXÀÇ ±âº» ÄÁÆ®·Ñ(Controls) |
|
|
|
|
|
|
[2008-07-31]
4.1
´Ù¾çÇÑ ¹öư(Button) ÄÁÆ®·Ñ |
|
11,126 |
|
|
|
|
[2008-08-13]
4.2 CheckBox¿Í EditBox |
|
7,532 |
|
|
|
|
[2008-08-25] 4.3 ¼¼»ó¿¡ µÑµµ ¾ø´Â "¿¢¼¿
Æ÷Åä °¶·¯¸®" ¸¸µé±â |
|
14,474 |
|
|
|
|
|
|
|
|
 |
±âŸ
À¯¿ëÇÑ ³ëÇÏ¿ì |
|
|
|
|
|
|
|
[2008-06-13] 1. ¹ö±×ÀÇ À¯·¡¿Í µð¹ö±ë(Debugging) Å×Å©´Ð
|
|
21,180 |
|
|
|
|
[2008-06-18]
2. ¹ö±×¸¦ ÁÙÀÌ´Â 5°¡Áö ¹æ¹ý ¹× ¿¢¼¿ÀÇ µð¹ö±ë Åø |
|
7,493 |
|
|
|
|
[2008-11-27]
3. Ãß°¡ ±â´É(Add-ins) ÆÄÀÏ ¸¸µé±â
 |
|
111,930 |
|
|
|
|
|
|
|