Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 3 Then Exit Sub
With Target
If .Value = "atiendhold@yahoo.com.cn" & Chr(10) & "DIKEIDM@TOMTOM.COM" Then
.AddComment
.Comment.Text Text:="1.This message was transferred with a trial version," & Chr(10) & "2) I will not in the office in Monday,May 16 and will back in Tuesday,May 17." & ""
.Comment.Shape.TextFrame.AutoSize = True
End If
End With
End Sub