Replacing too many logical statements in IF-ELSE Condition

Hello Excel gurus!

As the title suggests, is there a way on how I can compress lines and lines of logical/conditional statements in an IF-ELSE statement? I have been searching for an applicable and most effective approach but they offer solutions a bit far from what I want to achieve.

For example.
I want to check if multiple Textboxes in a userform hold values or simply empty, and then execute some action.

Please Login or Register  to view this content.

I am using the For...Next looping statement in some of part the program, but am not able to apply it in this instance.

Below is the sample of my code with looping statement.

Please Login or Register  to view this content.

Hope you can give me a shorter way to do this.

Thanks in advance.

In a userform, there are multiple textboxes for user input, and a command button needs to check if all textboxes are filled out before say, going to the next userform. All of the textboxes need to be checked all at the same time, so that proceeding to the next userform will be stopped in case one of them holds no value (or empty).

To answer your question Norie, the textboxes need to be checked if one of them is empty.

Thanks.

I knew there is a better way to do this! Thanks a lot Norie!