B BBQKING3 Board Regular Joined Nov 16, 2005 Messages 76 Nov 28, 2005 #1 I need to validate two cells during a macro. If they don't match, end the macro and send the user a pop up message.
I need to validate two cells during a macro. If they don't match, end the macro and send the user a pop up message.
Norie Well-known Member Joined Apr 28, 2004 Messages 76,048 Office Version 365 Platform Windows Nov 28, 2005 #2 Like this perhaps. Code: If Range("A1").Value <>Range("A2").Value Then Msgbox "Mismatch, code terminating" Exit Sub End If
Like this perhaps. Code: If Range("A1").Value <>Range("A2").Value Then Msgbox "Mismatch, code terminating" Exit Sub End If