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

[µo°Ý] ªí³æ²£¥Íªº¿ù»~(µLªk½s¿è,µLªkÃö³¬)

[µo°Ý] ªí³æ²£¥Íªº¿ù»~(µLªk½s¿è,µLªkÃö³¬)

¥»©«³Ì«á¥Ñ bioleon69 ©ó 2017-6-3 16:39 ½s¿è

¦U¦ì¤j¤j¤È¦w

¬O³o¼Ëªº,¤p§Ì¦b½m²ßvbaªº¹Lµ{¤¤
µo¥Í¤@¨Çª¬ªp
------------------

¤u§@ªí¦b¸ê®Æ¼g¤J¤§«á,
·|µo¥Íªí®æ§¹¥þµLªk½s¿è,¤]µLªkÃö³¬µøµ¡ªº±¡ªp(¤£ª¾¬°¦ó,¤]¨S¥X²{¥ô¦ó¿ù»~µøµ¡)
Á`¤§,´N¬O¸Ó¤u§@ªí§¹¥þ¤£¯à½s¿è..
¦p¼v¤ù
https://www.youtube.com/watch?v=6F26dGiv9Jc

¸Ñ¨Mªº¤èªk´N¬O,¤Á´«¨ä¥L¤u§@ªí«á,¤~·|¥¿±`
§Ú¬O¥i¥H¦b³Ì«á­±¥[¤Wsheets("sheet2").select ¸Ñ¨M°ÝÃD
¤£¹L·Q¤F¸Ñ³oºØª¬ªp¥¿±`À³¸Ó«ç»ò¸Ñ¨M?
ÁÂÁÂ
¦]¬°¦³ªí³æ,©Ò¥H´Nª½±µªþ¤WÀÉ®×

¬yµ{¡G
¦bsheets1ªº¤T®Ø®Ø ¿é¤J  ¦~,¤ë,¤ë   ¨Ò(106,5,5)
¤§«á·|·s¼W¤@­Ó¤u§@ªí,¸ê®Æ±N¼g¤J·sªº¤u§@ªí¤º
µM«á¤£¯à½s¿èªí®æªºª¬ªp´N¥X²{¤F

get3.rar (57.43 KB)

ÁٽФj¯«­Ì«üÂI°g´b ÁÂÁÂ
VBA ±q0¶}©l
¥ý±q¾Ç·|¬ÝªºÀ´¶}©l
¥ý±q·|¦³°ò¥»­×§ï¯à¤O¶}©l
¤@¨B¤@¨B¾Ç²ß¤¤

¥»©«³Ì«á¥Ñ Hsieh ©ó 2017-6-15 10:17 ½s¿è

¦^´_ 1# bioleon69


    ªí³æ±j¨î¦^À³¼Ò¦¡
  1. Sub ±Ò°Êªí³æ()
  2. UserForm1.Show 0
  3. End Sub
½Æ»s¥N½X
©Î¬O°õ¦æµ²§ôÃö³¬ªí³æ§Y¥i
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD