µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ½Ð°Ý¦p¦ó¥ÎVBA©Î¨ä¥L¤è¦¡ÅýŪ±ø½X¦Û°Ê³sµ²Listbox¿ï³æ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
½Ð°Ý¦p¦ó¥ÎVBA©Î¨ä¥L¤è¦¡ÅýŪ±ø½X¦Û°Ê³sµ²Listbox¿ï³æ
jeffrey628litw
µoµu®ø®§
¥[¬°¦n¤Í
jeffrey628litw
·í«eÂ÷½u
UID
3715
©«¤l
228
¥DÃD
62
ºëµØ
0
¿n¤À
364
ª÷¿ú
364
ÂI¦W
20
§@·~¨t²Î
Win 10
³nÅ骩¥»
Office 2007 & 2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
1015 ¤p®É
µù¥U®É¶¡
2011-3-5
³Ì«áµn¿ý
2024-9-16
¤¤¾Ç¥Í
©«¤l
228
¥DÃD
62
ºëµØ
0
¿n¤À
364
ÂI¦W
20
§@·~¨t²Î
Win 10
³nÅ骩¥»
Office 2007 & 2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2011-3-5
³Ì«áµn¿ý
2024-9-16
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2014-11-23 21:57
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
½Ð°Ý¦p¦ó¥ÎVBA©Î¨ä¥L¤è¦¡ÅýŪ±ø½X¦Û°Ê³sµ²Listbox¿ï³æ
¦U¦ì¤j¤j¡A§Ú·Q°Ý¦pªG§Ú¥ÎBar Code ReaderŪ¤J¤@¸ê®Æ®w¤¤¤w«Ø¥ß¦nªº±ø½X(¨Ò¦p°²³]¬OÁp»Ê¨T¨®°Ó¦æ)¡AµM«á§Ú¦b¤u§@ªí "¨C¤é¿é¤J¸ê®Æªí"
ªºG2~P2¦³¥ÎVBA¼g10¼hListbox¤U©Ô¿ï³æ¡A¦p¦óÅý°Ê§@
1.Bar Code ReaderŪ¨ìªº±ø½X¦s¤JªºG2Àx¦s®æ¡GÁp»Ê¨T¨®°Ó¦æ
2.¦Û°ÊÅýListbox¹w¥ý±Ò°ÊÂI¿ï¡GÁp»Ê¨T¨®°Ó¦æ
3.´N¥i¥Hª½±µ¤â°Ê¿ï²Ä2¼h¤U©Ô¿ï³æHÄ檺¤º®e
4.µM«á¤â°Ê¤@ª½¿ï¨ìPÄ檺¤º®e
¶i¾P¦s¨t²Î¦p¤U¡G
http://www.FunP.Net/988311
¼Ó¥D¼ö©«
Excel ¦Û°Ê¤Æ±m¦â¥Ì¯S¹Ï
Excel ª«®Æ¨t²Î
½Ð°Ý¦p¦ó¦b1Àɮ׳]1-4±ø¥ó¡AµM«á¼´¥Xµ²ªG¨ì
Excel 5¼h¥H¤W¤U©Ô¿ï³æ (¤U©Ô¤å¦r)
Excel 1¡B2¡B3¡B4¡B5¼h¤U©Ô¿ï³æ (¼´¥X¤å¦r)
Excel ¤U©Ô¿ï³æÅã¥Ü¹Ï¤ù¨Ã¦Û°Ê¶}±ÒÀɮפαÐ
½Ð°Ý§Ú³oVBAþ¸Ì¦³°ÝÃD¡H¬°¤°»ò·|µLªk¥X²{
Excel ¨ç¼Æ»s§@ªº3Óª©¥»ªº¸U¦~¾ä
20160731 ³Ì·sExcel¾P¦s¨t²Î(¥]§t¾P³f³æ©Mª«
VBA - ²£«~¦Û°Ê§ì¹Ï¤Î¹Ï¤ùÅã¥Ü+¤ñ¹ï¨t²Î v.
¦¬ÂÃ
¤À¨É
ÀR«ä¦Û¦b :
°µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·