¶¡Â_¿é¤J®É ¦p¦óÅýµ{¦¡¤]¥i¥H±a¥X¸ê®Æ
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¶¡Â_¿é¤J®É ¦p¦óÅýµ{¦¡¤]¥i¥H±a¥X¸ê®Æ
Dear ¤j¤j
¤p§Ì²{¦³¤@Ó°ÝÃD ´N¬O³øªí¦b¿é¤J®É,¨Ï¥ÎªÌ·|¸õµÛ¿é¤J¸ê®Æ,¦ý§Úªº¼gªk«oµLªk§JªA³oÓ°ÝÃD
½Ð¤j¤j±Ð¾É¤@¤U¤p§Ì,¤]¶¶«K¦³·sªº«äºû,¥H«á¹J¨ì³o¼Ëªº°ÝÃD,´N¥i¥H¦Û¦æ¸Ñ¨M
ªþ¥ó¬°°ÝÃD¤§½d¥»
¶¡Â_¿é¤J®Éµ{¦¡¦p¦ó§JªA20110107.rar (10.17 KB)
|
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 2# oobird
Dear ¤j¤j~ §Ú±N§A¼¶¼gªºµ{¦¡½X©ñ¤J¨ì½d¥»¤¤,¦ý°õ¦æ«o§¹¥þµL¥ô¦ó°Ê§@
:dizzy:
¤j¤j ¤§«e§Ú¤]¦³¸Õ¹LPrivate Sub Worksheet_Change(ByVal Target As Range)
¦ý¥i¯à§Úªº¼gªk¤W¦³¿ù~ ¥¦·|¤@ª½pºâ
©Ò¥H~ §Ú¤~§ï¦¨Private Sub Worksheet_SelectionChange(ByVal Target As Range)
·í¿ï¾Üªº¦³§ïÅܮɴNpºâ~ |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 2# oobird
Dear ¤j¤j
«á¨Ó§Ú¦³´ú¸Õ§â¨ä¤¤ªº¤@¦æ®³±¼´N¥i¥H¹F¨ì»Ý¨D,¦ý³o¦æ®³±¼·|¤£·|¦³¤°»ò¼Ëªº°ÝÃD©O??
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 2 Then Exit Sub <----§â¸Ó¦æ®³±¼´N¥i¥H°õ¦æ
On Error Resume Next
Target(1, 2) = Sheet2.[b:b].Find(Target, , , 1)(1, 2).Value
End Sub |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 5# oobird
Dear ¤j¤j
Target <---³oÓ·N«ä¬O¤°»ò §Ú¥ÎF1¬d¸ß³Q¥¼§ä¨ì³oÓ¦rªº¥Îªk¸ò»¡©ú |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
Dear ¤j¤j
Y°²³]§Ú»Ýn±qData1»PData2¤¤ ¦U¦ÛªºSheet¤¤¤ñ¹ï¸ê®Æ«á,±N¸ê®Æ±a¥X¨Ó,³o¼Ë¸Ó¦p¦óקï
»¡©ú:
1. ¦bsheet[¿é¤J]¤¤,{A}¶ñ¤J¸ê®Æ±a¥XDATA1¤¤ªºBÄæ¦ì¸ê®Æ
2. §Q¥ÎBÄæ¦ì¸ê®Æ±a¥XDATA2¤¤CÄæ¦ì¸ê®Æ
(¥ý«e±ø¥óData1»PData2ªºªí®æ¸ê®Æ¬O¦b¥¼¥[¤u¥B¤£¯à¾ã¦X¦b¤@°_ªº±¡ªp¤U)
°ÝÃD¦pªþ¥ó¤§½d¥»
¶¡Â_¿é¤J®É µ{¦¡¦p¦ó§JªA_©µ¦ùÃD2.rar (12.47 KB)
|
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 8# GBKEE
Dear ¤j¤j
§Aªº¤è¦¡¥i¥H§¹¥þ¸Ñ¨M§Úªº°ÝÃD,¨Ã¥B¤]«Ü²³æªº¼W¥[(©ÎÂX¼W)§Úªº¨ä¥L±ø¥ó~
¦ý¤j¤j §Ú¦³´XÓ¦a¤è¬Ý¤£À´
1. ÅܼÆ.Count ?????????
2.IsNumeric(I) ¬O§_¸ÑŪ IsNumeric§P§O[I]¬OTRUE©Î¬OFALSE
¥t¥~§Ú¬O¥Î¥t¥~¤@Ó¤j¤jªº¼gªk¨Óקï,½Ð¤j¤jÀ°¦£¬Ý¤@¤U,³o¼Ëªº¼gªk¦³¤°»ò¼Ëªº¯Ê¥¢
If (Target.Count > 1 Or Target.Column <> 2) And (Target.Count > 2 Or Target.Column <> 3) Then Exit Sub
On Error Resume Next
Target(1, 2) = Sheet2.[b:b].Find(Target, , , 1)(1, 2).Value
If Target.Count > 2 Or Target.Column <> 3 Then Exit Sub
On Error Resume Next
Target(1, 2) = Sheet3.[b:b].Find(Target, , , 1)(1, 2).Value |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 11# GBKEE
ÁÂÁ¤j¤jªº´£¿ô~ ¦b¨Ï¥Î¤W·|ÄYÂÔ¨Ç
¤j¤j¬O§_¥i¥HÁ|¨Ò On Error Resume Next ·|¤£©ú©öµo²{¿ù°Èªº±¡ªp~ µ¹«á¾Çªº±ß½ú°Ñ¦Ò~ |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 11# GBKEE
Dear ¤j¤j
ü~ ¤S¦³°ÝÃD¤F
¦]¬°§Úªº¸ê®Æ¿é¤J¦@¤À¦¨¨â¶ô
Part1:¿é¤J[A]«á±a¥X[B][C]
Part2:¿é¤J[B1][C1]±a¥X[A1] PS:Part1»PPart2¦b¦P¤@¦æ¤W,¥i¥H¤À§Oº¡¨¬¦U¦Ûªº±ø¥ó«á,¦Û¦æ«ÂйBºâ
¥ÎWorksheet_SelectionChange©ÎWorksheet_Change,¥i¥H¦Û°Ê¥~¥X[A][A1],¦ý¬O»Ýn[A]¦A«ö¤@¦¸(CHANGE),¤~·|¦A¹Bºâ
°£¤F¥ÎCommandButton(¸Ó¶ñªº¦a¤è¶ñ§¹«á¦A«ö),¬O§_¦³¨ä¥L¤è¦¡¥i¥H§JªA,¥un§Úº¡¨¬§Ú©Ò»Ýnªº±ø¥ó«á,´Npºâ
ªþ¥ó¬°°ÝÃD¤§½d¥»
¶¡Â_¿é¤J®É µ{¦¡¦p¦ó§JªA_©µ¦ùÃD3.rar (12.85 KB)
|
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 15# Hsieh
Dear ¤j¤j Y²{¦b§ï¦¨¥Î«ö¶s¦¡ªº¤è¦¡³B²z (¥Dn¬O§Ú¦³¤@³¡¥÷¸ê®Æn¦Û°Êpºâ~¤@³¡¥÷¬O»Ýn¶×¥X«á¸ê®Æ¦^¶ñ«á¦Apºâ~)
³o¼Ë ByVal Target As Range ¬O§_´NµLªk¨Ï¥Î¤F
¸Ó¦p¦ó³B²zÅý¶¡Â_ªº¸ê®Æ¥i¥H¦b«ö¤U«ö¶s«á¶i¦æ¹Bºâ~
°ÝÃD½d¥»¤£ÅÜ (³Ì«á¤@¦¸ªº½d¥») |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|