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

[¤À¨É] À°¤pªB¤Í·Å²ß»{¦r¥y

[¤À¨É] À°¤pªB¤Í·Å²ß»{¦r¥y

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-4-7 01:03 ½s¿è

¥ÎExcel°µ¤F¤@­ÓÀ°¤pªB¤Í·Å²ß»{¦r¥y
_
¥Ñ©ó¨à¤l¬O¥ªºJ¤l, ©Ò¥H¦³­Ósheetªº±±¨î¦b¥ªÃä
_
«ö"¤W¤U"«ö¶s, ¶¶§ÇÅã¥Ü
_
­«½Æ«öElliot/Ines (¦b"¤W¤U"«ö¶s¤U­±), ¶Ã§ÇÅã¥Ü
_
¥t¤@Ã䪺List Box, ¥Î¨Ó¿ï¾Ü¤£¦P¤é´Á¤º®e
_
¥i¥Hhighlight³æ­Ó¤¤¤å¦r
_
¦b®a°t¦Xtouch screen®ÄªG«Ü¦n
_
Elliot[Sheet] ¹ïÀ³ EDB[Sheet]
Ines[Sheet] ¹ïÀ³ IDB[Sheet]

·Å²ß¤¤­^¦r¥y.rar (50.28 KB)

ss

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-4-7 01:09 ½s¿è

¯S·NÁ׶}¨Ï¥ÎVBA, ¤£µM¥i¥H¹ê²{§ó¦h¥\¯à.
ss

TOP

Åwªïµ¹·N¨£(¥\¯à, §ï¶i)
ss

TOP

§ó·s: ­^¤å¦r¥y®É, ¤£Åã¥Ühighlight

Åwªïµ¹·N¨£. :)

·Å²ß¤¤­^¦r¥y v2.rar (50.04 KB)
ss

TOP

¦^´_ 4# sunnyso


    ¸Õª±¤F¤@¤U¡A¦Û»s¨àµ£°V½m¤u¨ãªººc·Q¯uªº¤£¿ù¤]«Ü¥Î¤ß¡A¥i±¤§Ú¨à¤k³£­n¤W¤j¾Ç¤F¡A¤£µM´N¥i¥Hµ¹¦o­Ì¸Õ¥Î¡A¦A±N¤ß±o¦^õXµ¹§A¡C
   
   «Øij¥i¥H¼W¥[¤@¨Ç¥\¯à
1.  ¥i¥H°O¿ý³o¨Ç¥y¤lÅã¥Ü¹L´X¹M¡A§¹¦¨¡B¥¼§¹¦¨...µ¥¼Ð°O¡A¤U¦¸½m²ß¥i¥H¿ï¾Ü¥¼§¹¦¨¶µ¥Ø
2. ¥[¤@¨Ç¹ªÀy©Êªº¤å¦r¡B¹Ïµe....¡A·í¨àµ£³sÄòµª¹ï®É¡A´N«ö¼úÀy«ö¶s¡A´N·|¥X²{ ...Åý¤p«Ä¦³¦¨´N·P¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

«Ü¦nªº«Øij, ¬Ý¨Ó­n¨Ï¥ÎVBA°Õ
ss

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD