Thank you for your response i appreciate the help you're trying to give me. I rearranged my code as per your suggestion but I'm running into the same problem.

My code is setup so that if the user wants to retry I am calling my function again and starting from the beginning. So I keep on looping if the user makes a mistake and wants to re-enter information.

If the user wants to exit after making a mistake the FIRST...

I have a problem, the Exit Sub command is not working for some reason. If the user says NO to the MsgBox I want to stop the code, but the program just continues to execute.

I have use breakpoints and traced the code and found that the Exit Sub command is only working 50% of the time.


tempNumber = MsgBox("Try Again?", 292)
'If the user wants to try again
If tempNumber = 6...