你是想在输入的时候提示吗?例如A列代码如下Private Sub Worksheet_Change(ByVal Target As Range)
Dim r&, i&
If Target.Column = 1 And Target.Count = 1 Then
r = Target.Row
i = Application.CountIf(Range("A1:A" & r), Target.Value)
If i > 1 Then
MsgBox Target.Value & "重复了"
End If
End If...