|
学习 修改王佩丰的字典案例 来做个库存管理的应用,在出库 库存结算时,判定库存大于等于领用量时的IF 不执行,直接跳到Else去。
调试检查 发现 实际值 肯定是满足 if 条件的,不知道为什么? 请高手帮忙看看问题出在哪
代码如下:
Private Sub CommandButton3_Click()
Dim DDID As String
Dim i
'库存表赋值brr,
brr = Sheet3.Range("a2:f" & Sheet3.Range("a65536").End(xlUp).Row)
If Me.ListBox4.ListCount > 0 Then
i = Sheet4.Range("a65536").End(xlUp).Row + 1
DDID = "LY" & Format(VBA.Now, "yyyymmddhhmmss")
For j = 0 To Me.ListBox4.ListCount - 1
'提前判定库存量
Dim m
For m = 1 To Sheet3.Range("a65536").End(xlUp).Row - 1
'库存列表中找到对应的项目
If brr(m, 1) = Me.ListBox4.List(j, 0) Then
Debug.Print brr(m, 5)
Debug.Print Me.ListBox4.List(j, 4)
' 问题是:调试中 下面的If条件是成立的,就是不执行,直接跳到Else 去??
If brr(m, 5) >= Me.ListBox4.List(j, 4) Then
brr(m, 5) = brr(m, 5) - Me.ListBox4.List(j, 4)
Sheet3.Range("e" & m + 1) = brr(m, 5)
MsgBox "剩余库存:" & brr(m, 5)
Sheet4.Range("a" & i) = DDID
Sheet4.Range("b" & i) = Date
Sheet4.Range("c" & i) = Me.ListBox4.List(j, 0)
Sheet4.Range("d" & i) = Me.ListBox4.List(j, 1)
Sheet4.Range("e" & i) = Me.ListBox4.List(j, 2)
Sheet4.Range("f" & i) = Me.ListBox4.List(j, 3)
Sheet4.Range("g" & i) = Me.ListBox4.List(j, 4)
Sheet4.Range("h" & i) = Me.ListBox4.List(j, 5)
i = i + 1
Else
MsgBox Me.ListBox4.List(j, 0) & "库存不足,请尽快确认补货"
End If
End If
Next
Next
MsgBox "领用成功"
Unload Me
Else
MsgBox "选择清单为空"
End If
End Sub
|
|