楼主需要的是VBA,可用Change事件,例只对A列
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Count = 1 Then
If Not IsNumeric(Target) Then
MsgBox "请输入数字!"
Target = ""
End If
End If
End Sub
楼主需要的是VBA,可用Change事件,例只对A列
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And Target.Count = 1 Then
If Not IsNumeric(Target) Then
MsgBox "请输入数字!"
Target = ""
End If
End If
End Sub