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

[µo°Ý] Private Sub µ{¦¡½X«OÅ@

[µo°Ý] Private Sub µ{¦¡½X«OÅ@

µ{¦¡½X¦³³]©w±K½X«OÅ@¡A¦ý¬O§Úµo²{­Y±N­Ó§O¤u§@ªí½Æ»s¥X¨Ó¡AÁöµM¼Ò²Õ¸Ìªºµ{¦¡½X(Sub)¤£·|³Q¤@¨Ö½Æ»s¥X¨Ó¡A¦ý¬O¼g¦b­Ó§O¤u§@ªí¸Ìªºµ{¦¡½X(Private Sub)´N¤@ÄýµL¿ò¤F¡A¦³¨S¦³¤èªk¥i¥HÁקK³o­Óº|¬}¡C
Jess

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-12-10 16:01 ½s¿è

¦^´_ 1# jesscc

   
    ³Ì²³æªº°µªk¬O
1.¾Þ±±excel ¥t¶}¤@­Ó·sÀÉ ¦s¦¨xlsx

¥t¤@­Ó¤ñ¸û¥j©Çªº°µªk(¦Û¤v·Qªº)
2.§Aªº¤u§@ªí¤@¼Ë¼g¨Æ¥ó
¨Ã¥B¥Î¤@­ÓÁôÂäu§@ªí¬ö¿ý2­Ó°Ñ¼Æ(targetªº¦ì¸m ¸ò subªº¦WºÙ)¡@¡@¡@¡@­Y§A·|ÈЪ«¥óÃþ§O¼Ò²ÕÈФ]¥i¥H¥Î
¾ã­Ó¨Æ¥ó¤ºªºµ{¦¡½X­n
·h²¾¨ì¤@¯ë¼Ò²Õ­«¼g¦¨¤@­Ó·sªºsub¡@¡@
¦Ó¨Æ¥óIJµoÄ~Äò¯d¦b¤u§@ªí
¦ý§A¥i¯à¦³­ÓºÃ°Ý
¨º¨Æ¥ó¤£´N¶]¤£°Ê¤F¶Ü?
ÁÙ¬O¯à¶] ­n°µ¤â¸}

¨Æ¥ó¥»¨­­n°µ¤@­Óif °²¦p§ä¤£¨ìÁôÂäu§@ªí ¨º´Nfales
¤]´N¬O¨Æ¥ó¥Ã»·¤£·|IJµo ¦ý¤@¼Ë¥u¦³¨Æ¥ó«e¬q·|¸òµÛ¤u§@ªí ¦ý¯u¥¿ªºcode¥þ³¡¨S¦³

­Y¦³µo²{ÁôÂäu§@ªí  ¨Æ¥ó´N·|Ä~Äò¨«¤U¥h
´N¥Î application.run "sub¦WºÙ"  Ä~Äò©I¥s³Q§A·h¨ì¤@¯ë¼Ò²Õªºsub
¦Ó³o­Ó³Q¯ë¨ì¤@¯ë¼Ò²Õªºsub ·|¥h ÁôÂäu§@ªí¸Ì­±§ì¨útargetªº¦ì¸m
µM«á¬Ý§A«ç»ò§Q¥Î  ­n¦A­«set¦¨ ª«¥ó¤]¥i¥H

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD