ªð¦^¦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)

¦^´_ 12# c_c_lai

·PÁ±оɡA¯¬°·±d§Ö¼Ö¡C

TOP

¦^´_ 10# ©P¤j°¶
¦bµ{¦¡¼¶¼g¹Lµ{¤¤¡A³Ì¦n¾i¦¨¨Æ«e¥¿½T¦a°µÅܼƫŧi¡A
²ö­n°½Ãi±¼³o­Ó«Å§i²ßºD¡A¦p¦¹§A¥i¥H¥þ½L²z¸Ñ¼¶¼g
¤§µ{¦¡¦b°õ¦æÀô¹Ò¤¤§êºt¤§¸}¦â¦a¦ì¡A¦P®É¦b¨Æ«á¤§
µ{¦¡­×¥¿¤ÎºûÅ@¤W¥ç¸û¦³±ø²z»P®e©ö¡C
©Ò¥H«ØijÁÙ¬O¤£­n¥h±Ë option explicit ªº»yªk¡C

TOP

¬Ý§¹¦¹½g¾ã¦ê¹ï¸Ü¡A
±q¬Y­Ó¨¤«×¨Ó»¡¡A¤W­±¾ã¦ê¹ï¸ÜÁÙÆZ......¦³½ìªºXD

³oÀ³¸Ó´N¬O¼Ð·Çªºµo°ÝªÌ»P¸ÑÃDªÌ»{ª¾¦³¤@ÂIÂI...¤£¦P~«¢

Á|¨Ò¨Ó»¡¡Aª©¥D¦b8¼Ó°Ý¡G¦p®³±¼option explicit, ´N¸Ó¦p¦ó®³±¼
¦ý¨ä¹ê i¤j ¦b7¼Ó¤w¸g§â8¼Ó°ÝÃDªº¥D­nªºµª®×»¡¥X¨Ó¤F¡G¥²¶·«Å§i§A¨C¤@­Ó¨Ï¥ÎªºÅܼÆ~^^

TOP

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

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

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

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

¦^´_ 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

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

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD