¦p¦ó§Q¥ÎVBA¤@Áä¦Û°Ê¶ñ¤J1©Î3©O?
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ 10# ã´£³¡ªL
¦n©Ç¡A§â±zªºVBA¶K¦bSheet2¤u§@ªí«á¡A¦bCÄæ¸Ì¤@ª½×§ï¤º®e¡A¤]¨S¨£¥L¦Û°Ê¶ñ¤J©O?
¬O§Ú¶K¿ù¦ì¸mÁÙ¬O»Ýn¬Æ»ò¨ä¥L°Ê§@¶Ü?
¹ï¤F¡I§Ú·|IJµoªº "¦Û°Ê¶ñ¤J" ªº×§ïCÄ檺½d³ò¦³¼W¥[¨ìC3:C200³á¡A¦]¬°¦³®É¨Ï¥ÎªÌ·|²§°Ê¨ì100¦h¦C¡A©Ò¥H§Ú°®¯Ü§â½d³ò¼W¥[¨ìC200¤]·|IJµo¡C |
|
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-26
|
¦^´_ 11# RCRG
¤½¦¡¤Îµ{¦¡¤£¬O»IÃĶK¤F´N¥Î, ¥ý¥h¤F¸Ñ¤@¤U, ¦³°ÝÃD¸ÕµÛ¥hקï¦A´ú¸Õ¬Ý¬Ý~~ |
|
|
|
|
|
|
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ 10# ã´£³¡ªL
ÁÂÁÂã¤jªº«ü¥¿¡A´ú¸Õªºªºµ²ªG¡A§Ú¦n¹³§ä¤£¨ìקïCÄæ¦ì«á´N¦Û°Ê¶ñ¤Jªº¡A¦³¤@¨Ç³£¬O§Ú¥u¬O·Æ¹«ÂI¿ïCÄæ¦ì¡AÁÙ¨Sקï´N¶ñ¤J¤F¡A¤£ª¾ÁÙ¦³¨ä¥L¥i¥H¿ï¶Ü
|
|
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-26
|
¦^´_ 13# RCRG
Private Sub Worksheet_Change(ByVal Target As Range)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
¬Ý¤@¤U¨âªÌ¤£¦P³B, ¥i°Ñ¦ÒVBE»¡©ú~~¨Æ¥ó~~ |
|
|
|
|
|
|
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦^´_ 14# ã´£³¡ªL
ÁÂÁÂã¤j¸Ñµª¡A°Ñ·Ó±zªºµª®×¡A§Ú¦Û¤v¦AÅܧó¤@¤U¤âªk¡A¤]ºâ¬O¥i¥H¦Û°ÊIJµo¤F¡A¦A¤@¦¸·PÁ±z¦h¦¸ªºÀ°¦£¡I |
|
|
|
|
|
|
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¦p¦ó§Q¥ÎVBA¤@Áä¦Û°Ê¶ñ¤J1©Î3©O? Part2
http://forum.twbts.com/viewthrea ... a=pageD1&page=1
¤W¦Cºô§}¬Oì°ÝÃD»P¸Ñµª¡F
¦ý¬O³Ìªñ¤S¦³·sªº»Ý¨D¡A´N¬O¦pªG¦Û°Ê¦bBÄæ¦ì¶ñ¤J1©Î3«á¡A¦³¨Ç¨Ï¥ÎªÌ·|»~§ï¨ìBÄæ¦ì¦Û°Ê¶ñ¤Jªº¼ÆÈ¡A
¤£ª¾¯à§_ ¼u¥Xµøµ¡ "¶ñ¤J¸¹½X»P¹w³]¤£¦P¡A½Ð½T»{¬O§_nקï¡I" ¨Ó´£¿ô¤@¤U¨Ï¥ÎªÌ¡C
¥H¤W°ÝÃD¡A¦³³Ò¤j¤jÀ°¸Ñ¡I |
|
|
|
|
|
|
- ©«¤l
- 95
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-11-10
- ³Ì«áµn¿ý
- 2020-5-25
|
¤W¦Cºô§}¬Oì°ÝÃD»P¸Ñµª¡F
¦ý¬O³Ìªñ¤S¦³·sªº»Ý¨D¡A´N¬O¦pªG¦Û°Ê¦bBÄæ¦ì¶ñ¤J1©Î3«á¡A¦³¨Ç¨Ï¥ÎªÌ·|»~§ï¨ì ...
RCRG µoªí©ó 2015-11-24 16:39
ì¨Ó³o¼Ëºâ«½Æµo©«¡AÁÂÁª©¤j´£¿ô»PÀ°¦£¦X¨Ö¡A¤]§Æ±æ¦U¦ì¤j¤j¯àÀ°¸Ñ¤W1¼Ó(16¼Ó)PATR2°ÝÃD¡A3Q¡I |
|
|
|
|
|
|
- ©«¤l
- 36
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- MICROSOFT
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-6-7
- ³Ì«áµn¿ý
- 2024-9-22
|
¦^´_ 3# ã´£³¡ªL
½Ð°Ýã¤j,¡@.Formula = "=IF(C3="""","""",3^(1-COUNT(MATCH(C3,AA$2:AA$500,))))"¤¤
COUNT(MATCH(C3,AA$2:AA$500,))))ªºÈn¹À¬O0,n¹À¬O1,µ²ªG¤~¯àÅã¥Ü¥X1©Î3,¦ÓMATCH¬O§ä¥X¬Û²Å©Ò¦bªº¦ì¸m,¨Ò¦p¥i¯à§ä¨ì¦b²Ä400¦C,³o¼Ë«ç»ò·|±o¥X0©Î1ªºµ²ªG? |
|
|
|
|
|
|
- ©«¤l
- 36
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- MICROSOFT
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-6-7
- ³Ì«áµn¿ý
- 2024-9-22
|
¦^´_ 18# ¤d·u´M
§ä¨ìµª®×¤F,ì¨Ó¬OCOUNTªº§@¥Î:§ä¨ì¥]§t¼Æ¦rªºÀx¦s®æÓ¼Æ,©Ò¥HMATCHªºµ²ªG¤£ºÞ¬O¦ó¼Æ¦r(©Î§ä¤£¨ì),µ²§½¤£¬O0´N¬O1! |
|
|
|
|
|
|
- ©«¤l
- 522
- ¥DÃD
- 36
- ºëµØ
- 1
- ¿n¤À
- 603
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp sp3
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-13
- ³Ì«áµn¿ý
- 2021-7-11
|
¦^´_ 10# ã´£³¡ªL
§Q¥Î3^0, 3^1¨Ó¶ñ¤J1©Î3, ¯u§®, «ôªA, ¦¬¤U, ÁÂÁÂ!! |
|
|
|
|
|
|