ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§Ó­â±Ð¾Çºô¼v­µ±Ð¾Ç--Excel 2007/2010 VBA ¸ò§Ú¾Ç--

§Ó­â±Ð¾Çºô¼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µh­W¾Ç²ß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-2­q»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

¹ê¥Îªº±Ð¾Ç¼v­µ

ÁÂÁÂjoey¤jªº¤À¨É

:  )

TOP

¦n²Ó¿°ªº±Ð¾Ç±a
¹ïªì¤JExcel-VBA¥@¬Éªº¦nÀ°¤â
·PÁª©¤j

TOP

¦n¦³¤ßªººô¯¸¡AÀ°ªì¾ÇªÌ(´N¬O§Ú..)¾ã²z¤FVBAªº³\¦h·§©À¡A¦A·f°t³o­Ó½×¾Âªº¤@¨Ç¤å³¹¤Îµo°Ý¡AÀ³¸Ó¥i¥H¾Ç²ßªº§ó§Ö¡AÁÂÁÂjoey0415¤j¤j¤À¨ÉÅo

TOP

¹ê¥Îªº±Ð¾Ç¼v­µ

ÁÂÁÂjoey¤jªº¤À¨É

TOP

·PÁ¤À¨É
­è¤Jªù
­è¦n¦³³o­Ó±Ð¾Ç¥i¥H¤Þ¶iªù
Hello

TOP

¹ê¥Îªº¤º®e
À°§U¤JªùªÌ§ä¨ì
¥¿½T¾Ç²ßªº¸ô®|

TOP

·PÁ¤F¡A¥[¤J§Úªº³Ì·R¡I
·s¤H¤@ªT

TOP

ÁÂÁ°Õ!
³o¹ï©ó·Q¾ÇEXCEL VBAªºªB¤Í¬O¤@¤jºÖ­µ°Ú!!!!

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD