Help with a warning Box

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

thornden4

Try changing this row

Please Login or Register  to view this content.

for this

Please Login or Register  to view this content.

Windy

Originally Posted by windy58

thornden4

Try changing this row

Please Login or Register  to view this content.

for this

Please Login or Register  to view this content.

Windy

Windy you have been a life saver. Thanks so much.