Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Target.Column <> 6 Then Exit Sub
If Target.NumberFormatLocal <> "yyyy/mm/dd" Then
Application.EnableEvents = False
MsgBox "请按照“YYYY/MM/DD”格式输入年月日!", 64
Target = ""
Application.EnableEvents = True
End If
End Sub