qiongmei 发表于 2015-4-3 06:57
谢谢2个高手师傅的回答,您们的代码正是我所希望的,我的表达不清楚,但是2楼的师傅很能理解我的意思,但能 ...
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column > 1 And Target.Column < 5 And Target.Row > 2 Then
If Application.CountIf(Sheets("花名册").[a:a], Target) = 0 Then
MsgBox "该号无人"
: Target = ""
Else
Target = Sheets("花名册").[a:a].Find(Target)(1, 2)
End If
End If
Application.EnableEvents = True
End Sub