ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD