|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
稍微修改了一下:
Private Sub tb_kh_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Application.EnableEvents = True
If Len(Trim(tb_yc.Value)) > 0 And KeyCode = vbKeyReturn Then
khb = Split(tb_kh.Value, "@")
lb_kxh.Caption = khb(0)
If UBound(khb) > 0 Then lb_kqty.Caption = khb(1)
Else
Exit Sub
End If
If lb_yxh.Caption = lb_kxh.Caption Then
pk_xh.Caption = "√"
Else
pk_xh.Caption = "×"
pk_pk.Caption = "型号不符"
If pk_pk.Caption = "型号不符" Then
Application.Speech.Speak "型号不符"
Application.EnableEvents = False
Exit Sub
End If
End If
If lb_yqty.Caption = lb_kqty.Caption Then
pk_qty.Caption = "√"
Else
pk_qty.Caption = "×"
Application.Speech.Speak "数量有误"
Application.EnableEvents = False
End If
If pk_xh.Caption = "√" And pk_qty.Caption = "√" Then
pk_pk.Caption = "√"
tb_yc.SelLength = Len(tb_kh.Value)
lb_cpx.Caption = ""
Else
pk_pk.Caption = "×"
End If
End Sub |
|