Excel Video 427 Exiting Loops

If you find a problem as you’re looping through data, watch Excel Video 427 to learn how to stop the loop so you can fix the problem. Notice how we use an IF statement to check for blank statement dates. If we find a blank statement date, we use a message box to tell the user about the problem and the row with the missing date. As long as the patient has a statement date, the logic and the loop continues. There’s a bunch more things we can do with message boxes that I’ll review once we survive looping in VBA. In the meantime, I hope you’re finding these videos on looping helpful. Thanks for watching.