so I am trying my first private worksheet macro and having a problem with my second statement . if the 1st test passes everything works great. if the second test fails the message box just keeps repeating
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("b5") = "Loyalty2gether"...
I have a procedure that includes a few msgbox's. The are just simple vbOkOnly boxes but when the user hits ok that do not unload.
The code continues as normal and the other msgboxs just sit on top of one another.
There's nothing fundamentally wrong with the code but doesnt...