- ©«¤l
- 15
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-7-22
- ³Ì«áµn¿ý
- 2015-7-21
|
§Ú¦bºô¤WªF§ä¦è´M¼g¦n¤F¤@Ó¤½¥q¨«³f¥ÎªºEXCEL
¦ý¦³®ÉÔ¦n¹³·|¨S¦³¦^À³
¼È®Éµo²{¤F°ÝÃDªº¦³¨âÓ
1 , ¨Ï¥Î¹p®gºj¦b SI ¤è®æ¿é¤J«á¤£À´¸õ¨ìBAR CODE®æ
2 , ¦bBAR CODE¦æ¿é¤J«ö¤UENTER¨S¦³°õ¦æADD / ERRORADD
§Ú³]©wªº±ø¥ó¬O
1 , ¨â®æ³£n¦³10Ó¦r , ¤è¥i°õ¦æ ADD
2 , ¦bSI®æ¨S¦³¸ê®Æ®É , BAR CODE¿é¤J¦r®É¦Û°Ê¸õ¨ì SI ®æ
3 , ¦bSI®æ¦³10Ó¦r®É , BAR CODE¨S¦³ªF¦è«ö¤UENTER ¤£·|°õ¦æ ERRORADD (¨¾¤î¦³³fª««ö¦íÁä½L¤ÞPµL°õ¦æERRORADD)
4 , ¦bSI®æ¦³10Ó¦r®É , BAR CODE 0Ó¦r¥H¥~ / ¤£¬O10Ó¦r °õ¦æ ERRORADD
5 , BAR CODE¨S¦³¥ô¦óMSGBOX (¨¾¤î¨Ï¥ÎªÌ¨S¦³¯d·N¤U¸õ¹L¤F¤U¤@ÓBAR CODE)
§Úı±o°Ý¬O¦b³o¸Ì...- Private Sub bar_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
- If si.Value Like "" Then
- Me.si.SetFocus
- End If
- If KeyCode <> 13 Then Exit Sub
- If si.Value Like "??????????" Then
- If bar.Value Like "??????????" Then
- add
- Me.bar.SetFocus
- Me.bar.Value = ""
- End If
- End If
- If si.Value Like "??????????" Then
- If bar.Value Like "" Then
- Me.bar.SetFocus
- Me.bar.Value = ""
- Else
- erroradd
- End If
- End If
- noExit = True
- End Sub
½Æ»s¥N½X END IF©ñªk¬O§_¦³¿ù?
¥ýÁÂ!
TakegoodsRecords.zip (23.24 KB)
|
|