|
在thisworkbook下
- Option Explicit
- Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
- If Not CheckVal Then Cancel = True
- End Sub
- Function CheckVal() As Boolean
- Dim sh As Worksheet, lngCol As Long
- Dim arrTarget As Variant
- Dim arrSum As Variant
- Dim strSex As String, strType As String, strVal As String
-
- Set sh = Sheets("Sheet1")
- arrTarget = sh.Range("B3:J5")
- arrSum = sh.Range("B6:J6")
-
- For lngCol = LBound(arrTarget, 2) To UBound(arrTarget, 2)
- strSex = arrTarget(1, lngCol)
- strType = arrTarget(2, lngCol)
- strVal = arrTarget(3, lngCol)
- If arrTarget(3, lngCol) <> arrSum(1, lngCol) Then
- MsgBox strSex & strType & "未等于" & Format(strVal, "0.00%")
- CheckVal = False
- Exit Function
- End If
- Next
-
- CheckVal = True
- End Function
复制代码 |
|