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

µ{¦¡½X©ñ¦bThis worksheet©Mmoduleªº®t²§©Ê(¤w¸Ñ¨M)

µ{¦¡½X©ñ¦bThis worksheet©Mmoduleªº®t²§©Ê(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ jiuhtsair ©ó 2011-8-23 17:55 ½s¿è

¥´¶}VBAªº½sĶµ{¦¡¡Aµo²{¦³sheet1¡Bsheet2...this worksheet©Mmoduleµ¥°Ï°ì¡I
¾Ú¤F¸Ñµ{¦¡½X®z¶Õ¦bsheet1«h¥u¦³¦bsheet1¦³¥\¯à¡A¦ýµ{¦¡½X©ñ¦bthis worksheet©Mmoudle¦³¦ó¤£¦P?
¸Ó¦p¦ó°Ï§O¦ó®É©ñ¦bthis worksheet¡A¦ó®É©ñ¦bmoudle¡H
ÁÂÁ¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦pªG¬O Private¡A ©ñ¦b sheet1 ´N¥u¦³ sheet1 ¯à¤Þ¥Î (CALL)¡C

¦pªG¬O Public¡A ©ñ­þ³£¥i¥H¡C
¦ý¬O¦pªG Module1¡B Module2 ¦U¦³¤@­Ó Public Sub test1( )¡A¤Þ¥Î®É´N±o«ü©ú¸ô®|¡C¨Ò¦p¡G
Module1.test1

TOP

ÁŵM¶}®Ô¡CÁÂÁ¡I
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 1# jiuhtsair


    this worksheet ´N¦n¤ñ ¤@­Ó¯Z¯Åªº¦Ñ®v  ©Ò²[»\ªº¯Z¯Å(½d³ò) ¥u¦³¥Ø«e©Ò¦bªº¯Z¯Å(½d³ò)
¦Ó module ´N¦n¤ñ¥D¥ô  ¥i¥H¦P®É²[»\«Ü¦h¯Z¯Å(½d³ò)


PS ­Ó¤H²z¸Ñ..

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD