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

[­ì³Ð] ¦p¦ó±NVBAµ{¦¡ _Âà´«¦¨¤@¯ë°ª¤â¤@¶}©l¬Ý¤£À´ªºªF¦è

[­ì³Ð] ¦p¦ó±NVBAµ{¦¡ _Âà´«¦¨¤@¯ë°ª¤â¤@¶}©l¬Ý¤£À´ªºªF¦è

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2010-12-13 23:45 ½s¿è

¦p¦ó±NVBAµ{¦¡ _Âà´«¦¨¤@¯ë°ª¤â¤@¶}©l¬Ý¤£À´ªºªF¦è
¨Ï¥Î"¯}¸ÑEXCEL¤u§@ªí«O护"¨Ó°µ­×§ï
»s§@§¹¦¨«áÂà´«µ{¦¡
¨ä¥\¯àÅܬ°:±Nµ{¦¡´Ó¤J¬¡°Ê¤¤ªº¬¡­¶Ã¯


VBAµ{¦¡¤¤¬Ý¤£¨ì¤@¨ÇªF¦è
µ{¦¡¤âªk¤£¤Ó¤@¼Ë ¦³¿³½ìªº¨Ó¬Ý¬Ý§a
A2 .rar (19.29 KB)

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-6-1 00:20 ½s¿è

³o½g¤ñ¸û§Nªù¡A¨S¤°»ò¥Î
¬Ý¨ìªù¹Dªº¤H­û¤´¤£¦h
¥D­n­n¦³¿³½ì¡A¦¹½g¥i¯àÄݤNÆp
¦¹½g§¹¥þ¨Ï¥Î¤@¯ëexcel»s§@¡AµL¨ä¥L³nÅé¡A¬O­È±o¬ã¨s

³o½g½Æ¦X¤TºØ¯S®íÃþ«¬«OÅ@«O±K§Þ¥©¡A¥D»¡©ú¤w¼¶¼g¦b¯f¬r¬ÛÃö©«»P«O±K©«¤¤ "°ª¤¤¥Í"¥H¤W¥i¾\Ū

TOP

¦^´_ 2# HUNGCHILIN
½T¹ê¬O: ¤@¯ë°ª¤â¤@¶}©l¬Ý¤£À´ªºªF¦è
¤×¨ä¬O: VBA¤¤¥u«OÅ@ Excelª«¥ó, ¤£«OÅ@ ¼Ò²Õ. ½Ð¤@©w­n¸Ñ»¡¤@¤U
µ{¦¡½X:  OnAction = "AddmodAB"  ·|«ü¦V  ActiveWorkbook ,¦b¨ä¥LWorkbook·|§ä¤£¨ì
§Ú¨Ì§Aªººc·Q­×§ï¤@¤U½Ð½ç±Ð         ¯}¸Ñ¤u§@ªí.rar (8.73 KB)
1

µû¤À¤H¼Æ

    • HUNGCHILIN: «Ü¤£¿ùªº«ä¸ô¡A¥i¥H§@¦¨¥u¥Î¤@¦¸©Êªº¦w¸Ë¤u ...ª÷¿ú + 3

TOP

·Q¤U¸ü¾Ç²ß¤U
¦ý¤£°÷Åv­­,
¥u¯à§V¤O¤É¯Å¤F,
¨þ
ÁÂÁÂ

TOP

§Ú«Ü·Q¾Ç, Åý¤u§@¸`¬Ù®É¶¡

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD