果然有效,之前没有注意到这个。
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim rng As Range
For Each rng In Target
If Not rng.Validation.Value Then
Application.Undo
MsgBox prompt:="粘贴数据超出可输入范围!", Title:="输入提示"
Exit For
End If
Next
End Sub Excel帮你不加班.pdf(1.65 MB, 下载次数: 143)