Message Box Fails to Appear

[rpokorny]

I am writing code to have a message box appear when data from two spreadsheets do not match. When I run the code the first time the message box appears. If I run the macro a second time, the message box will not appear. If I modify the code and run the macro, the message box will appear, but will not appear the second time, or thereafter. I don't get any error messages and the code runs correctly. The only thing not working is the message box failing to appear on the screen. I have run a test in a blank worksheet and the message box appears everytime I run the macro.

Here is the code:

Please Login or Register  to view this content.

[rpokorny]

After further testing, the message box seems to be displaying but disappearing so fast that the user can't see it. If I run through step mode it works every time. I thought the message box would display until the user clicks the OK button.

[stnkynts]

Works just fine for me when tested. Something else is going on to cause this, not sure what.