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

½Ð¨D«e½ú­Ì¨ó§U¬Ý¬Ýµ{¦¡¥X¿ù³B,

½Ð¨D«e½ú­Ì¨ó§U¬Ý¬Ýµ{¦¡¥X¿ù³B,

½Ð¨D«e½ú­Ì¨ó§U¬Ý¬Ýµ{¦¡¥X¿ù³B,
ªþÀÉ, ¤º¦³»¡©ú,
·PÁÂ!!!
zzz.zip (26.96 KB)

¦^´_ 1# ©P¤j°¶

¤£¤Ó²M·¡±zªº±¡ªp
¦pªG·QÁקKIJµo¨Æ¥óªº¸Ü¥i¥H¥Î
Application.EnableEvents=false
¦ý­Y¥i¥H¬Ý¨ì­ìÀÉ®×·|¤ñ¸û²M·¡±zªº°ÝÃD
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

¦^´_ 2# iamaraymond
ÁÂÁ«e½ú¦^À³,
¤p§Ì¿ù§â­ìÀɮפW¶Ç, ²{§â¦³µ{¦¡ÀÉ®×­«·s¤W¶Ç, §Æ±æ¯à±o¨ì¨ó§U, ÁÂÁÂ, ·P®¦..
nnnn.zip (31.81 KB)

TOP

¦^´_ 3# ©P¤j°¶

±z»¡ªº¿ù»~¬O¤£¬OÅܼƥ¼©w¸q?
¦pªG¬Oªº¸Ü¥u­n¦b
Private Sub Worksheet_SelectionChange(ByVal T As Range)
©³¤U¥[¤@¥y
Dim c As Variant

À³¸Ó´N¥i¥H¤F
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

¦^´_ 4# iamaraymond
·PÁ«e½ú,
¥[¤J³o¥y, °ÝÃD¤w¸Ñ决, ÁÂÁ¨ó§U, ¯¬¨­Åé°·±d, §Ö¼Ö..ÁÂÁÂ!!

TOP

¦^´_ 4# iamaraymond
«e½ú, ¦­±á
·Qª¾¦hÂI,
Private Sub Worksheet_SelectionChange(ByVal T As Range)
©³¤U¥[¤@¥y
Dim c As Variant
°£¤F³o¥[¦h¤@¥y, ¥iÁÙ¦³¨ä¥L»yªk©Î¤èªk¨ú¥N,
¨ä¹ê¥[¦h¤@¥y«á, °ÝÃD¤w¸Ñ决, ¥u¬O·Qª¾¦hD, ¾Ç¦hD,
ÁÂÁÂ!!

TOP

¥»©«³Ì«á¥Ñ iamaraymond ©ó 2018-5-27 11:05 ½s¿è

¦^´_ 6# ©P¤j°¶

¨ä¹ê³o­Ó°ÝÃD·½¦Û©ó³Ì¤W­±¨º¤@¥y
option explicit
­Y¼g¤F³o¥y»yªk´N¥Nªí­n¥²¶·«Å§i§A¨C¤@­Ó¨Ï¥ÎªºÅܼÆ
¨Ò¦p®·ªº³o¤@¥y
dim c as variant
´N¬O«Å§ic³o­ÓÅܼƬO¤@­Óvariantªº«¬ºA

¨Ï¥Îoption explicit¦³´X­ÓÀuÂI¬O
1.µ{¦¡·|¹B¦æ¸û§Ö¡A¦]¬°§A«Å§i¤F¨C¤@­ÓÅܼơA¨º»ò¹q¸£´N¤£­nÁÙ­nªá®É¶¡À°§A§PÂ_­þ­ÓÅܼƬO­þ­ÓÃþ«¬
2.­°§C¿ù»~²v¡A¦³®É­Ô§Ú­Ì·|¤£¤p¤ß¥´¿ù¦r
¨Ò¦p§Ú¤µ¤Ñ¥Îstockno¬ö¿ýªÑ²¼¥N¸¹¡Aµ²ªG§Ú«á­±¦b¨Ï¥Î®É¤£¤p¤ßº|¤F¤@­Ó¦r¥´¦¨stckno¡A¨º³o¼Ë´N¥i¯à³y¦¨µ{¦¡¥X¿ù
¦Ó¨Ï¥Îoption explicit¥L´N·|À°§AÀˬd¡A¦b§Aµ{¦¡¹B§@¤§«e¡A¥L´N·|¸ò§A»¡stckno¨S©w¸q
³o®É­Ô§A´N¥i¥HÀˬd¨ì§A¥´¿ù¦r¤F

¦ý³Â·Ðªº¬O...¨C¤@­ÓÅܼƳ£­n©w¸qXD

©Ò¥H¥t¤@­Ó¸Ñ¨M¤è¦¡´N¬O§âoption explicit®³±¼
¥L´N¤£·|±j¨î§A¨C­ÓÅܼƳ£­n©w¸q¤F
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

¦^´_ 7# iamaraymond
¤j¤j¦­±á
¤p§Ì¨ü±Ð¤F, ¦ý§ÚÁÙ¬O·Q¦V¤j¤j½Ð±Ð, ¦p®³±¼option explicit, ´N¸Ó¦p¦ó®³±¼, §Æ±æ¤j¤j«üÂI, ÁÂÁÂ!!

TOP

¦^´_ 8# ©P¤j°¶

±z¬O»¡¦p¦ó®³±¼¶Ü?
´N§âoption explicit³o¥y§R±¼´N¦n
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

¦^´_ 9# iamaraymond
ÁÂÁ¤j¤j,
©ú¥Õ,
¯¬°·±d, §Ö¼Ö..

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD