Private Sub Worksheet_Change(ByVal Target As Range)
Dim a
If Target.Count = 1 Then
a = Target.Value
If TypeName(a) <> "Date" Then
MsgBox "你输入的不是日期格式,请重新输入"
Target.ClearContents 清空内容
End If
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim a
If Target.Count = 1 Then
a = Target.Value
If TypeName(a) <> "Date" Then
MsgBox "你输入的不是日期格式,请重新输入"
Target.ClearContents 清空内容
End If
End If
End Sub