Excel Video 427 Exiting Loops from vba to date Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: 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
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)