Check if ANY cell in range is empty

Hi, me again,

I have a chunk of code to loop through a range of 30 cells and check for null values. Various cells will contain text, numbers, and time/date data. Basically, I need to validate that all required fields in a form contain a value. I don't care what value at this point, I'll handle that with built in data validation.

I am using the following code:

Please Login or Register  to view this content.

This approach is working but the loop triggers the MsgBox for each empty cell. So, if all cells are blank, the user has to click out of the message box 30 times. Is there another approach that would only trigger the message box once and bailout of the procedure if ANY empty cell is found? Thanks for the help.

I figured it out:

Added Exit sub after the MsgBox line:

Please Login or Register  to view this content.

Hey, thanks. I just figured out the same solution and tested it. It's working. I appreciate the quick response though. Reps to you!