I am hopelessly confused.
I have an IF statment that is simply not working. The statement SHOULD call a message box and exit the Sub when the value in a cell (in this case, V51) contains the value "TRUE".
V51 contains a formula that returns TRUE or FALSE based on the entry in multiple cells.
THE ISSUE:
When running the code the message box will not trigger when the value is TRUE.
Can't figure out what I have done or am doing wrong.
THE CODE:
If Range("V51").Value = "TRUE" Then
MsgBox "*** VALUE MISMATCH ***", vbCritical, "CHECK ENTRY"
Me.EnableEvents = True
Exit Sub
End If
Thank you in advace for your help. Will be away from a computer until the morning. Thank you in advance for your assistance.
Peace.
Bookmarks