- If (Range("PriceZero").Value > 0 AND Range("ISPAY").Value = "未结算") Then
- If MessageBox.Show("有商品单价填写不完整,请确认是否继续进行财务结算?", "结算提醒", MessageBoxButton.OKCancel) = MessageBoxResult.OK Then
- Range("ISPAY").Value = "已结算"
- End if
- ElseIF Range("ISPAY").Value = "已结算" Then
- If MessageBox.Show("是否取消结算状态?", "取消结算提醒", MessageBoxButton.OKCancel) = MessageBoxResult.OK Then
- Range("ISPAY").Value = "未结算"
- End if
- ElseIF Range("ISPAY").Value = "未结算" OR Range("ISPAY").Value = "" Then
- If MessageBox.Show("立即进行财务结算,请点击确认!", "结算提醒", MessageBoxButton.OKCancel) = MessageBoxResult.OK Then
- Range("ISPAY").Value = "已结算"
- End if
- End If
复制代码
|
|
hessen