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

[µo°Ý] ·j´M³Ì«á¤@¦C³£¦³¬Û¦P¼Æ¦rªº²Õ¦X¡C

[µo°Ý] ·j´M³Ì«á¤@¦C³£¦³¬Û¦P¼Æ¦rªº²Õ¦X¡C

¬Û¦P¼Æ¦rªº²Õ¦X.rar (99.39 KB)

»Ý¨D¡J
¥HRrngA InputBox¥ô¨ú¤@­Ó¶}¼úª©(DATA!)ªº´Á¼Æ¤Î¨ä¶ñ¤JCrngA InputBoxªºÄæ¦ì¼Æ(²ºÙA²Õ¦X)¡F
¥t¥HRrngB InputBox¥ô¨ú¤@­Ó¶}¼úª©(DATA!)ªº´Á¼Æ¤Î¨ä¶ñ¤JCrngB InputBoxªºÄæ¦ì¼Æ(²ºÙB²Õ¦X)¡F
·íA²Õ¦X©MB²Õ¦X©MA*Bªº²Õ¦X³£²Å¦X°ò¥»Å޿誺±ø¥ó¥B¤T­Ó²Õ¦X¤§¦UÅçÃÒª©ªº³Ì«á¤@¦C¤]³£¦³Åã¥Ü¬Û¦Pªº¸¹½X®É¡A«h²£¥Í®ÄªGÀɮסF§_«h¤£²£¥Í®ÄªGÀɮסC

¨ä¾l...¸Ô¦p¤W¶Ç½d¨Ò»¡©ú¡C

·q½Ð¦U¦ì¤j¤j«ü¾É¡C·P®¦~~~~~~~~~~~

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-2-4 20:01 ½s¿è

¦^´_ 72# c_c_lai
°ò¥»¬[ºcÄY®æ»¡¥u§¹¦¨~~¶}¼úª©ªºA¤ñ¹ï°ò·Ç¦C´Á¼ÆÄæ¦ì©MB¤ñ¹ï°ò·Ç¦C´Á¼ÆÄæ¦ìªº©³¦â¼Ð¥Ü~~
¨ä¾lªº¤£¬O¤£§¹¾ã¤£µM´N¬O¿ù»~(¥]¬A70#ªº½d¨ÒÀÉ)¡A¦]¦¹¡A¤£¤~§¹¥þµLªk¥H¦¹Ãþ±À¶i¦æ­×¥¿¡C

¦ý³Ì­«­nªº¬O±zÁöµM±N»Ý¨D»¡©úªþµù¦bµ{¦¡¤º¡A¦ý«oÁ`¬O¤£¨Ì¾Úµo°ÝÃDªº»Ý¨D§@¸Ñ¡AÁö¸g¤£¤~ªº¤@¦A¸Ñ»¡¡A±zÁÙ¬OÁ`¥H¦Û¤vªºÆ[ÂI¨Ó¸ÑÃD~~
EX:¥H³Ì²³æªº¤u§@ªí¦WºÙ¡A©ú©ú¬OSheet1§Y¥i¡A¥B¥[¥ySheets("Sheet1").Move´N¥i±N®ÄªGÀɮק¹¦¨¡A¥i¬O±z«o¤@ª½°í«ù¤v·N§@¸Ñ¡C

ÁöµM²³æªº»yªk¡A¤£¤~¥i¥H¦Û¦æ­×¥¿¡A¦ýÁ`¤]­n¦³­Ó§¹¦¨ÀɨӰµ¼Ð·Ç¡F¦ý±zÁ`¬O¤£®Éªº´£¿ô­n¤£¤~¦Û¦æ±µ¤U¥h§¹¦¨~~
¤£¤~³Ì«áªº·Pı¬O"¤ßÄ@Ãø¥H¹F¦¨"¡A©Ò¥H¥u¯à¹ï¯Ô»~±z³\¦hªºÄ_¶Q®É¶¡·P¨ì©êºp!
¦A¦¸ÁÂÁ±zªº¼ö¤ß¨ó§U~~·P®¦

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-2-4 18:11 ½s¿è

¦^´_ 72# c_c_lai
°ò¥»¬[ºcªº´Á¼ÆÁÙ¬O¨S¦³¹ï»ô¡A
¤£¤~¦A¬Ý¬Ý~~~
ÁÂÁ±z^^"

TOP

¦^´_ 71# ziv976688
°ò¥»¬[ºc«Ø¸m·~¤w«Ø¥ß¡A§A¥i¥H°Ñ¦Òµ{¦¡¤º®e
¥H¦¹Ãþ±À¶i¦æ­×¥¿¡A±N¥¦§ï¦¨§A¯u¥¿ªº©Ò»Ý¡C
¦P®É¤]ÁÂÁ§A­@¤ßªº¸Ñ»¡¡A¤~¦³¤µ¤é¤§ªG¹ê¡C

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-2-4 12:12 ½s¿è

¦^´_ 70# c_c_lai
¶Q¸ÑµªÁöµM¤£²Å¦X¤£¤~©Ò»Ý¡F
¦ýÁÙ¬OÁÂÁ±zªº¼ö¤ß¨ó§U©M¤£§[½ç±Ð

TOP

¦^´_ 69# ziv976688
BASE_T-1-R1(MF).rar (51.4 KB)
A.png
2017-2-4 08:23

B.png
2017-2-4 08:24

C.png
2017-2-4 08:24

TOP

¦^´_ 67# c_c_lai
R1(MF)_T-1.rar (33.85 KB)
¥u³Ñ¤U¤@­Ó»~®t~~
¶}¼úª©©M¦U²Õªº²Ä1­ÓÅçÃÒ²Õ¦X­«½Æ¡A
EX:R1(MF)_T-1¡C
½Ð±N¶}¼úª©·í¬°¤ñ¹ïªº¥À¬q¸¨¡F¦UÅçÃÒ²Õ¦X·í¬°¤ñ¹ïªº¤l¬q¸¨¡C
ÁÂÁ±z^^

TOP

¦^´_ 67# c_c_lai


    ¨Ó¾Ç²ß¤F~~

TOP

¦^´_ 66# ziv976688
¦^´_ 63# Airman
¦A¸Õ¸Õ¬Ý§a¡I
BASE_T-1-R1(MF).rar (45.92 KB)
·j´M¬Û¦P¼Æ¦rªº²Õ¦Xµ{¦¡¹Lµ{¸Ñ»¡.rar (238.5 KB)

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-1-31 21:16 ½s¿è

¦^´_ 64# c_c_lai

À˵ø&»¡©ú.rar (53.89 KB)

¥J²Ó«ä¦Ò«á~~ÁÙ¬O¥H¶Q¸Ñµª¤u§@ªí¨Ó»¡©ú¤£²Å¦X»Ý¨Dªº¦a¤è¡A¦A¥t§@¥¿½Tµª®×ªº¤u§@ªí~¥H§Q±z­×¥¿µ{¦¡½X¡C

¥HÀ˵ø59#¶Q¸Ñµª¤u§@ªí1~10¡F¾ã²z«áªº¤£²Å¦X»Ý¨Dªº¦a¤è~~
1¡J¦U¤ñ¹ï°ò·Ç´Á¼Æ(¶}¼úª©)©M¦UÅçÃÒª©ªº´Á¼Æ~~¨S¦³¦P¦C»ô¥­¤ñ¹ï¡C
EX¡J¤u§@ªí1~10
2¡JB²Õ¦Xªº¤ñ¹ï°ò·Ç(¶}¼úª©)´Á¼Æ©M²Ä 1 ­Ó B ÅçÃÒª©´Á¼Æ­«½Æ(20=20)¡C
EX¡J¤u§@ªí5 & 6
3¡JC(=A*B)²Õ¦XªºÅçÃÒª©¤ñ¹ï´Á¼Æ¿ù»~(19-18=1<>23-20¡F16-16=0<>23-20=3 )¡C
EX¡J¤u§@ªí1 & 3  
4. A©ÎB©ÎC(=A*B)²Õ¦Xªº¤ñ¹ï°ò·Ç´Á¼Æ¼Ðªº©M«ü©wªºA©ÎB©ÎC(=A*B)²Õ¦Xªº´Á¼Æ¤£²Å¦X¡C
EX¡J¤u§@ªí1~10

¥H¤W¨Ñ°Ñ!­Õ©|¦³°ÝÃD·Ð½Ð§iª¾¡CÁÂÁ±z!

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD