§Óâ±Ð¾Çºô¼vµ±Ð¾Ç--Excel 2007/2010 VBA ¸ò§Ú¾Ç--
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
§Óâ±Ð¾Çºô¼vµ±Ð¾Ç--Excel 2007/2010 VBA ¸ò§Ú¾Ç--
http://www.yesgood.com.tw/contents/excel2007vba.aspx
²Ä¤@³¹ »´»´ÃPÃP»{ÃÑExcel VBA
1-1Excel¤u§@ªí»PExcel VBA
1-1-1¬°¤°»ò»ÝnExcel VBA
1-1-2¦p¦óµLµhW¾Ç²ßExcel VBA
1-2»{ÃÑVisual Basic½s¿èµøµ¡
1-3ªì¾ÇªÌ¤Jªù¾É¤Þ
1-3-1¿ý¼gExcel VBA¥¨¶°
1-3-2¾\Äý¿ý»sªºµ{¦¡¤º®e
1-3-3³v¦r³v¥y¿é¤J¡y¼¶¼gVBAµ{¦¡¡z
1-3-4Àx¦s»PÂ÷¶} Excel VBA
²Ä¤G³¹ Excel VBA¥¨¶°ªº³]p·§©À
2-1Excel VBAªº«n·§©À
2-1-1¥¨¶°»PVBAµ{§Ç
2-1-2»{ÃѪ«¥ó¡BÄÝ©Ê¡B¤èªk»P¨Æ¥ó
2-2µ{¦¡µ²ºc»P¤ÀÃþ
2-2-1µ{¦¡ªºµ²ºc
2-2-2µ{¦¡(µ{§Ç)Ãþ«¬
2-2-3µ{§Ç¦WºÙªº©R¦W³W«h
2-3VBAªº¸ê®ÆÃþ«¬
2-3-1¦UºØ¸ê®Æ«¬ºA
2-3-2¸ê®Æªºªí¥Ü¤èªk
2-3-3»{ÃÑÅܼƻP±`¼Æ
2-4¼¶¼g³¯z¦¡ªº«n·§©À
2-4-1³¯z¦¡ªºÃþ«¬
2-4-2¼¶¼g³¯z¦¡ªº§Þ¥©
2-4-3Â_¦æ¡B¦h¦æ»Pµù¸Ñªº³B²z
2-4-4²¤Æ¿ï¨ú«ü¥O
2-4-5³]©w¦Û¤v²ßºDªº½s¿èÀô¹Ò
2-5¸ê®Æªº«Å§i»P¦³®Ä½d³ò
2-5-1«Å§iÅܼÆ
2-5-2«Å§i±`¼Æ
2-5-3«Å§i°}¦C
2-5-4¸ê®Æªº¦³®Ä½d³ò
²Ä¤T³¹ µ{¦¡¬yµ{ªº±±¨î
3-1¨Mµ¦±±¨î
3-1-1³æ¤@¿ï¾Üµ²ºc
3-1-2Âù¦V¿ï¾Üµ²ºc4
3-1-3±_ª¬µ²ºc
3-1-4¦h¦V¿ï¾ÜSelect Case³¯z¦¡
3-2GoTo±j¨î§ïÅܬyµ{
3-3°j°é±±¨î
3-3-1Do¡KLoop °j°é±±¨î
3-3-2For¡KNext °j°é±±¨î
3-3-3For Each¡KNext°j°é±±¨î
3-3-4¸õÂ÷°j°é±±¨î
²Ä¥|³¹ Excel VB±`¥Îªºµ{¦¡
4-1ExcelÀÉ®×(¬¡¶Ã¯)ªº³B²z
4-1-1¶}±ÒÀÉ®×(¬¡¶Ã¯)
4-1-2Àx¦s»PÃö³¬ÀÉ®×
4-1-3µøµ¡Åã¥Üªº³B²z
4-2Excel¤u§@ªíªº³B²z
4-2-1¤u§@ªíªº©R¦W
4-2-2¤u§@ªíªº¿ï¨ú»P±Ò°Ê
4-2-3¤u§@ªíªº½s¿è
4-3Àx¦s®æªº°Ñ·Ó·N¸q
4-3-1µ´¹ï°Ñ·Ó»P¬Û¹ï°Ñ·Ó
4-3-2R1C1 »P A1 ªí¥Üªkªº·N¸q
4-3-3µ´¹ï¿ý¼g»P¬Û¹ï¿ý¼g
4-4Excel VBA¤¤Àx¦s®æªº©w¸q
4-4-1¨Ï¥ÎRangeÄÝ©Ê°Ñ·Ó
4-4-2¨Ï¥Î Cells ÄÝ©Ê°Ñ·Ó
4-4-3¨Ï¥ÎOffsetÄÝ©Ê
4-4-4¨Ï¥Î¦WºÙ°Ñ·Ó
4-5¿ï¨úÀx¦s®æ½d³òªº§Þ¥©
4-5-1§@¥ÎÀx¦s®æªº³B²z
4-5-2¿ï¨ú¤u§@°Ï³Ì©³ºÝÀx¦s®æ
4-5-3¯S®í¿ï¨ú
4-5-4Äæ»P¦Cªº¿ï¨ú
4-5-5Union¡BIntersect»PAreas
4-6À³¥Î³nÅ骫¥óªº³B²z
4-6-1ĵ¥Ü°T®§ªº³B²z
4-6-2¨ä¥L±`¥Îªº¥\¯à
4-7¨Æ¥óµ{§Çªº«nÀ³¥Î
²Ä¤³¹ µ{§Ç»P¨ç¼Æ
5-1¤½¥Î»P¨p¦³µ{§Ç
5-2Functionµ{§Ç
5-2-1¨Ï¥ÎªÌ¦Ûq¨ç¼Æ
5-2-2¨Ï¥ÎFunctionµ{§Ç
5-3¤º«Ø¨ç¼Æ
5-3-1¼Æ¾Ç¨ç¼Æ
5-3-2¦r¦ê¨ç¼Æ
5-3-3¤é´Á¨ç¼Æ
5-3-4MsgBox¨ç¼Æ
5-3-5InputBox¨ç¼Æ
5-4Propertyµ{§Ç(Äݩʵ{§Ç)
5-5µ{§Ç»Pµ{§Ç¶¡ªº©I¥s
5-5-1¦b¦P¤@¬¡¶Ã¯¤¤µ{§Ç©¼¦¹©I¥s
5-5-2¦b¤£¦P¬¡¶Ã¯¤¤©I¥sµ{§Ç
²Ä¤»³¹ µ{¦¡(¥¨¶°)ªº°õ¦æ»P°»¿ù
6-1¥¨¶°ªº¦w¥þ©Ê³]©w
6-2«ü©w°õ¦æ¥¨¶°ªº¦ì¸m©Îª«¥ó
6-2-1±N¥¨¶°«ü©w¨ì¤u¨ã¶s
6-2-2±N¥¨¶°«ü©w¦Ü¤u§@ªí¤¤ªºª«¥ó
6-3µ{¦¡(¥¨¶°)°£¿ù§Þ¥©
6-3-1µ{¦¡¿ù»~ªºÃþ«¬
6-3-2¨Æ¥ý¨¾½d--Is¨ç¼Æ
6-3-3On Error³¯z¦¡--®·®»¿ù»~
6-4¶i¦æ°»¿ù¤u§@
6-4-1°õ¦æµ{¦¡ªº¤èªk
6-4-2ºÊ¬Ýµ{¦¡°õ¦æ¹Lµ{
6-5¨ä¥L°»¿ùµøµ¡
6-5-1¨Ï¥Î°Ï°ìÅܼƵøµ¡
6-5-2¨Ï¥Î§Y®É¹Bºâµøµ¡
6-5-3©I¥s°ïÅ|
²Ä¤C³¹ ¦b¤u§@ªí¤¤¨Ï¥Î±±¨î¶µª«¥ó
7-1»{Ãѱ±¨î¶µª«¥ó
7-2¨Ï¥ÎActiveX±±¨î¶µª«¥ó
7-2-1¥[¤JActiveX±±¨î¶µª«¥ó
7-2-2³]©w±±¨î¶µª«¥óªºÄÝ©Ê
7-2-3¦U±±¨î¶µª«¥ó¤§ÄÝ©Ê
7-3¼¶¼g¨Æ¥óµ{§Ç
7-3-1ActiveXªº¨Æ¥óµ{§Ç
7-3-2«OÅ@¤u§@ªíªº¨Æ¥óµ{§Ç
7-4¨Ï¥Îªí³æ±±¨î¶µª«¥ó
²Ä¤K³¹ ¦Ûq¨Ï¥ÎªÌ¤¶±
8-1¦Ûq¥\¯à°Ï¯Á¤Þ¼ÐÅÒ»P«ü¥O
8-1-1«Ø¥ß XMLÀÉ®×
8-1-2«Ø¥ßXLSM¥¨¶°¬¡¶Ã¯
8-1-3½s× .relsÀɮפº®e
8-2q»s¶Ç²Î¥\¯àªí»P¤u¨ã¦C
8-2-1¥HVBA«Ø¥ß¤u¨ã¦C©Î¥\¯àªí
8-2-2¥HVBA«Ø¥ß§ÖÅã¥\¯àªí
8-2-3ºÞ²z©R¥O¦C
8-3¦Ûqªí³æ(¹ï¸Ü¤è¶ô)
8-3-1«Ø¥ßªí³æ(¹ï¸Ü¤è¶ô)
8-3-2¥[¤Jªí³æ¤¸¥ó
8-3-3©w¦ì¶¶§Ç
8-3-4³]©wªì©lÈ»P¶Ç¦^¿é¤JÈ
8-4¨Ï¥ÎExcel¤º«Ø¹ï¸Ü¤è¶ô
²Ä¤E³¹ ¹Ï§Î»P¹Ïªíª«¥óªº³B²z
9-1¹Ï§Îª«¥ó
9-1-1¦b¤u§@ªí¥[¤J¹Ï§Îª«¥ó
9-1-2¹Ï§Îª«¥óªº±`¥ÎÄÝ©Ê»P¤èªk
9-1-3½s׹ϧΪ«¥ó
9-2¹Ïªíª«¥ó
9-2-1¹Ïªíª«¥óªºµ²ºc
9-2-2«Ø¥ß¹Ïªíª«¥ó
9-2-3¹Ïªíª«¥ó±`¥ÎªºÄÝ©Ê»P¤èªk
9-2-4½s×¹Ïªíª«¥ó
²Ä¤Q³¹ ¼W¯q¶°(Add-In)ªº¶}µo»P¨Ï¥Î
10-1¼W¯q¶°°ò¥»·§©À
10-2¨Ï¥ÎExcel¤º«Øªº¼W¯q¶°
10-3¦Û¤v¶}µo¼W¯q¶°(Add-In)
10-4¨Ï¥Î¦Û¤v¶}µoªº¼W¯q¶°
GoodTV ¤÷¿Ëªº·R |
|
|
|
|
|
|
- ©«¤l
- 2
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-11-18
- ³Ì«áµn¿ý
- 2013-11-26
|
¦n²Ó¿°ªº±Ð¾Ç±a
¹ïªì¤JExcel-VBA¥@¬Éªº¦nÀ°¤â
·PÁª©¤j |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-9-12
- ³Ì«áµn¿ý
- 2014-1-17
|
¦n¦³¤ßªººô¯¸¡AÀ°ªì¾ÇªÌ(´N¬O§Ú..)¾ã²z¤FVBAªº³\¦h·§©À¡A¦A·f°t³oӽ׾ªº¤@¨Ç¤å³¹¤Îµo°Ý¡AÀ³¸Ó¥i¥H¾Ç²ßªº§ó§Ö¡AÁÂÁÂjoey0415¤j¤j¤À¨ÉÅo |
|
|
|
|
|
|
- ©«¤l
- 2
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-7-12
- ³Ì«áµn¿ý
- 2013-11-29
|
¹ê¥Îªº±Ð¾Ç¼vµ
ÁÂÁÂjoey¤jªº¤À¨É |
|
|
|
|
|
|
- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2013-12-31
- ³Ì«áµn¿ý
- 2014-1-3
|
·PÁ¤À¨É
è¤Jªù
è¦n¦³³oӱоǥi¥H¤Þ¶iªù |
|
Hello
|
|
|
|
|
- ©«¤l
- 2
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- window xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2014-1-3
- ³Ì«áµn¿ý
- 2015-4-30
|
¹ê¥Îªº¤º®e
À°§U¤JªùªÌ§ä¨ì
¥¿½T¾Ç²ßªº¸ô®| |
|
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 110
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2013-7-14
- ³Ì«áµn¿ý
- 2018-10-3
|
|
·s¤H¤@ªT
|
|
|
|
|
- ©«¤l
- 72
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 126
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-4-2
- ³Ì«áµn¿ý
- 2016-1-14
|
ÁÂÁ°Õ!
³o¹ï©ó·Q¾ÇEXCEL VBAªºªB¤Í¬O¤@¤jºÖµ°Ú!!!! |
|
|
|
|
|
|