- ©«¤l
- 192
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 194
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-9-22
- ³Ì«áµn¿ý
- 2020-8-28
|
¦^´_ 99# c_c_lai
¥ý«eªº¿z¿ï±ø¥ó¤¤¡A"TR±Æ¾÷&²£¥X" ªº "Package"Äæ¦ì
¥i§_¦b¤ñ¹ï«e¼W¥[BGA.QFN.QFP ³o3ºØ¯S®íªºª¬ªp°µ§PÂ_
BGA(=VFBGA / LFBGA / UFBGA / HS BGA / FCBGA / HFC BGA / FBGA / TFBGA / LBGA / PBGA...)
QFN(=aQFN / cQFN...)
QFP(=TQFP/LQFP...)
¦]¦¹³oÃ䪽±µ§P©w³o3ºØ«¬ºAªº¡A¥unŪ¨ìBGA.QFN.QFP ¡A¤£ºÞ«e±¥[¤F¤°»ò(XXXBGA . XXXQFN. XXXQFP)³£§P©w¬°¤@¼ËªºªF¦è
______________________________________¤U±¬O§Ú·s¼Wªºµ{¦¡½X¡A¦ý¬O¦³Bug...________________________________________________________
§Ú¦bListBox¤W¦³·s¼W¤@ÓBotton(¶q¤j¥¼±Æ¾÷)¡A¦ý¬O³B²z§¹«á¡Aµo²{§Úªºµ{¦¡½X¦n¹³§PŪ¦³°ÝÃD... ·Ó²z"TR±Æ¾÷&²£¥X"¤Wªº"¾÷¥x½s¸¹"¡A¹ïÀ³ªº¤Ï¦Ç¸ê®Æ³¡¤À(E.F.G.HÄæ)
¤@Ó¾÷¥x½s¸¹À³¸Ó¥u·|¥X²{¤@¦¸¡A¦ý¦³¥i¯à¹ïÀ³¨ìªº"¶q¤j¥¼±Æ¾÷"ªí¤¤¡A¦³¥i¯à¤@µ§¸ê°T·|¦P®É¦³1-4ºØ¤£¦Pªº¾÷¥x½s¸¹
·N«ä¬O:¥X²{¹Lªº¾÷¥x½s¸¹À³¤£¸Ó¦A¥X²{¤F¡APrivate Sub CommandButton2_Click()
¦³ªº®ÉÔ·|¥X²{¤U±ªþ¹Ï
§Ú¦b«e¸m§@·~¦³¥ý³B²zWIPªº¸ê®Æ 1.SÄæ¿z¥XLS1T|LS1N|TR|BK|VQ ¦r¦ê¡A¨ä¾lªº¤£n
2.±NJÄ檺"G"RÄ檺"R"¿z¥X¨Ó¡A¨ä¾lªº¤£n
3.'NÄ檺®É¶¡¡A¥H·í«e¨t²Î®É¶¡ + 4HRS ¤º ¿z¥X¨Ó¡AªÅ¥ÕµL®É¶¡¸ê®Æªº¿z¥X¨Ó¡A¨ä¾lªº¤£n(¨ä¾lªº«ü¤£¦b³o4HRS¥H¤ºªº¸ê®Æ)
4."U"Äæ«æ³f³æ¸¹¡A¦³¥ô¦óÈ¡A¦b"I"ÄæSchedule¥[¤W*¸¹
¤§«á¦A¼g¨ìSheet1
³oÃ䦳¤@Ó°ÝÃD¬O¡A§Úªº¥Îªk¤]·|§ó§ï¨ìWIP¤Wªº¸ê®Æ¡A*¸¹³¡¤À
¦ý°ÝÃD¦b¨Ï¥ÎªÌ¡A¦pªG¤â´Ý¤@ª½ÂIªº¸Ü¡A³oÓ¬P¸¹·|µL¤î¶iªº¼W¥[**********·|Åܦ¨¤@¤j°ï...
µM«á§Úµo²{§Ú¿z§¹«á¶K¥hSheet1ªº³¡¤À¡A¦³ªº®ÉÔ·|´Ý¯d¤§«eªº¸ê®Æ
->WIPªº¸ê®Æ¨C¤Ñ·|°µ§ó·s¡A§Ú¸Õ¹L¦n¹³n§âSheet1ªº¸ê®Æ¾ãÓ§R°£±¼¦b¥h°õ¦æ¡A¤ñ¸û¤£·|¥X°ÝÃD...
³oÃä§Ú¬O¦b"TR±Æ¾÷&²£¥X" °µ¤@ÓWIP§ó·sªº«ö¶s¡A¤§«e¦³·Q¹L§â³oÓ°õ¦æ¤]¤@¦P©ñ¤J Private Sub Worksheet_SelectionChange(ByVal Target As Range)
¦ý¬O¶]°_¨Ó·|«Ü¤[¡A¦Ó¥B¦³®ÉÔÅã¥Üªº¸ê®Æ·|¿ù»~¡A¦]¦¹³Ì«á¤~¥Î¤F³oÓ¿ìªk...³o³¡¤À¦³§ó¦nªº§@ªk¶Ü~
°t¤WC¤j¤§«eÀ°¦£×§ïªº¡AListBox1 & ListBox2 ¬Ò·|¨Ï¥Î¨ì¤u§@ªí2¸òShee1
Sub ArrangeMent() ¬O±qWIP¾ã²z¹L«áªº¸ê®Æ (Sheet1)pºâ¥X¨Óªº
´N¬O"¤u§@ªí2"
¼g¨ì¤u§@ªí2ªº³¡¤À¡A§Ú§â°õ¦æ©ñ¨ì Private Sub Worksheet_SelectionChange(ByVal Target As Range)
¥Ø«eÁÙ¨S¬Ý¨ì¿ù»~¡A¤£ª¾¹D©ñ¦b³oÃä¤é«á·|¤£·|¦³Bug
tx00001223.zip (792.4 KB)
|
|