|
|
|
VBA ÀÔ¹®°ÁÂ
VBAÀÇ ±âÃʺÎÅÍ Â÷±ÙÂ÷±Ù ¼³¸íÇØ ´Þ¶ó´Â ¸¹Àº ºÐµéÀÇ ¿äû¿¡ ÀÇÇØ VBA
ÀÔ¹®°Á¸¦ ½ÃÀÛÇÕ´Ï´Ù.
VBAÀÇ ±âÃÊ ¹× ÇÁ·Î±×·¡¹ÖÀÇ ±âº» °³³äÀ» Á¤¸³ÇϽôµ¥ ÀÛÀ¸³ª¸¶ µµ¿òÀÌ
µÇ¾úÀ¸¸é ÁÁ°Ú½À´Ï´Ù. |
|
|
|
|
|
 |
VBA¸¦ ¹è¿ì±â À§ÇÑ Çʼö ±âÃÊÁö½Ä
ÀÐÀ½¼ö |
|
|
|
|
|
|
|
[2002-11-19] 1. Introducing VBA (Visual Basic for Application) |
|
150,146 |
|
|
|
|
[2002-11-29] 2. ¾ÖÇø®ÄÉÀ̼Ç, ¿ÀºêÁ§Æ®, ÇÁ·ÎÆÛƼ ±×¸®°í ¸Þ¼µå |
|
79,882
|
|
|
|
|
[2002-12-20] 3.
¿öÅ©ºÏ ¿ÀºêÁ§Æ® |
|
63,388
|
|
|
|
|
[2003-04-25]
4. ¿öÅ©½ÃÆ® ¿ÀºêÁ§Æ® |
|
57,153
|
|
|
|
|
5. ·¹ÀÎÁö ¿ÀºêÁ§Æ®¸¦ »ý¼ºÇÏ´Â ¸î °¡Áö ¹æ¹ý |
|
|
|
|
|
|
[2004-04-10]
5.1 Range, Cells ¼Ó¼º |
|
72,899
|
|
|
|
|
[2004-05-18]
5.2 Rows, Columns, EntireRow, EntireColumn ¼Ó¼º |
|
53,391
|
|
|
|
|
[2004-12-10]
5.3 CurrentRegion, UsedRange ¼Ó¼º |
|
40,595
|
|
|
|
|
[2004-12-14]
5.4 Union,
Intersect ¸Þ¼µå |
|
36,622
|
|
|
|
|
[2004-12-28]
5.5 SpecialCells, End ¼Ó¼º |
|
37,250
|
|
|
|
|
[2005-03-21] 6.
Sub ÇÁ·Î½ÃÀú¿Í Function ÇÁ·Î½ÃÀú |
|
41,829
|
|
|
|
|
|
|
|
|
 |
Excel
2007ÀÇ ¸®º»
Ä¿½ºÅ͸¶ÀÌ¡ |
|
|
|
|
|
|
|
[2008-05-11] 1. ÅÇ(Tab)¿¡ ±×·ì Ãß°¡Çϱâ |
|
11,578 |
|
|
|
|
[2008-05-19] 2. ¸®º»¿¡ »õ·Î¿î ÅÇ Ãß°¡Çϱâ |
|
8,261 |
|
|
|
|
[2008-05-27] 3. ¿¢¼¿ 2007¿¡¼ µµ±¸ ¸ðÀ½ Èä³»³»±â |
|
7,957 |
|
|
|
|
4. RibbonXÀÇ ±âº» ÄÁÆ®·Ñ(Controls) |
|
|
|
|
|
|
[2008-07-31]
4.1
´Ù¾çÇÑ ¹öư(Button) ÄÁÆ®·Ñ |
|
7,193 |
|
|
|
|
[2008-08-13]
4.2 CheckBox¿Í EditBox |
|
5,258 |
|
|
|
|
[2008-08-25] 4.3 ¼¼»ó¿¡ µÑµµ ¾ø´Â "¿¢¼¿
Æ÷Åä °¶·¯¸®" ¸¸µé±â |
|
9,343 |
|
|
|
|
|
|
|
|
 |
±âŸ
À¯¿ëÇÑ ³ëÇÏ¿ì |
|
|
|
|
|
|
|
[2008-06-13] 1. ¹ö±×ÀÇ À¯·¡¿Í µð¹ö±ë(Debugging) Å×Å©´Ð
|
|
17,591 |
|
|
|
|
[2008-06-18]
2. ¹ö±×¸¦ ÁÙÀÌ´Â 5°¡Áö ¹æ¹ý ¹× ¿¢¼¿ÀÇ µð¹ö±ë Åø |
|
4,830 |
|
|
|
|
[2008-11-27]
3. Ãß°¡ ±â´É(Add-ins) ÆÄÀÏ ¸¸µé±â
 |
|
105,603 |
|
|
|
|
|
|
|