Hi, I would like to modify this code with the added And statement as shown below. Can someone help? Thanks
Revise to:
If Range("B23").Value <> "SR" and Range("AU20").Value = "ADD CONT SIDE" Or Range("AV20").Value = "ADD MOUNT TYPE" Then
response = MsgBox("CONTROL SIDES OR MOUNT INFO IS MISSING - HIT YES TO CONTINUE OR NO TO ABORT", vbYesNo)
If response = vbNo Then
Exit Sub
End If
End If
VBA Code:
If Range("AU20").Value = "ADD CONT SIDE" Or Range("AV20").Value = "ADD MOUNT TYPE" Then
response = MsgBox("CONTROL SIDES OR MOUNT INFO IS MISSING - HIT YES TO CONTINUE OR NO TO ABORT", vbYesNo)
If response = vbNo Then
Exit Sub
End If
End If
Revise to:
If Range("B23").Value <> "SR" and Range("AU20").Value = "ADD CONT SIDE" Or Range("AV20").Value = "ADD MOUNT TYPE" Then
response = MsgBox("CONTROL SIDES OR MOUNT INFO IS MISSING - HIT YES TO CONTINUE OR NO TO ABORT", vbYesNo)
If response = vbNo Then
Exit Sub
End If
End If