Stop SAVE Function IF any textbox is blank - Userforms

Hello!

As you can see in the code below, i am using IF COMBOBOX1.VALUE="" THEN show a textbox warning the user that they can not proceed if they don't fill out COMBOBOX1. Can't complain, it's working perfectly.

Problem: Now i have a Userform where we have 40 textboxes and/or Combobox(es).
Question: Rather than having to specify EACH ONE with code (like in the sample code shown below), is there a way to syntax it so that if ANY of the 40 textboxes or comboboxes value = "" THEN stop the rest of the process and tell the user to please check their work and try again?

Please Login or Register  to view this content.

Thanks! Any insight would be appreciated!!

RO

You could use something like this:

Please Login or Register  to view this content.

BSB