- ©«¤l
- 2798
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2854
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-4-15
|
¥»©«³Ì«á¥Ñ ã´£³¡ªL ©ó 2021-7-10 17:35 ½s¿è
¦^´_ 15# BV7BW
NM = [a2] '«È¤á
DD = [A4] '¤é´Á
Mch = Application.Match(CLng(DD), [q³f©ú²Óªí!k:k], 0) '¥ýÀˬd¤é´Á¬O§_¦s¦b
If IsNumeric(Mch) Then
Arr = Range([q³f©ú²Óªí!m1], [q³f©ú²Óªí!a1].Cells(Rows.Count, 1).End(xlUp))
For i = Mch To UBound(Arr)
If Arr(i, 11) <> DD Then Exit For
If Arr(i, 11) = DD And Arr(i, 1) = NM Then '¤é´Á¬Û¦P+«È¤á¬Û¦P
MsgBox "¡°¤é´Á:" & DD & "¡A«È¤á:" & NM & "¤w¸g¦³¸ê®Æ! ": Exit Sub
End If
Next i
End If
³o¼Ë´NµLªk±Nì³æ¥s¥X¨Óקï¼W¥[«~¶µ¤F!!! ¥ç§Y¦P¤@¤Ñ¦P¤@«È¤á¥u¯à¿é¤J¤@¦¸¸ê®Æ!
¤H¬°¿ù»~µ{¦¡¤j³¡¥÷µLªk±Æ°£, ¤@¯ë¥´³æ¤§«e¤@©w¦³¤â¼g¯ó½Z,
n¾i¦¨²ßºD, ¿é¤J®É, ¦P®É±N¯ó½Z¤Wªº«È¤á¦WºÙ©Î½s¸¹¥Îµ§°é°_¨Ó, ³o¬O¤@Ó«Ü«nªº½T»{°Ê§@,
¿é¤J§¹¦¨«á, ¤]¥²¶·¦b¯ó½Z¤W¼g¤U"³æ¸¹", ³o¼Ë´N¥i¥H±Æ°£«ÂЩÎkey¿ùªº°ÝÃD~~ |
|