Hi there,
Hoping someone can help.
I have a sheet that users will either mark cells with either a Y or a N.
Cell F20 I want a warning box to pop up if the user put in either N or n
I have tried the following and it works but I cannot figure how to include both (n and N)
Option Explicit
Dim StrMsg As String
Dim TitleMsg As String
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = "$F$20") Then
If (Target.Value = "n") Then
StrMsg = "If you are sure that this is a CALL FAIL, please continue to mark rest of call so that feedback can be given to advisor. Thanks."
TitleMsg = "CALL FAIL?"
MsgBox StrMsg, vbInformation, TitleMsg
End If
End If
End Sub
Bookmarks