How can I check all comboboxes for blanks within a userfor?

Hello all,
This is question 1 of 3. I will post the other 2 in their own threads.
In the attached I have a simple userform with 3 comboboxes and 1 textbox. What I would like to do is, when the Submit button is clicked, check 3 comboboxes and 1 textbox for blanks. If ANY number of them are blank, I want to set focus to the 1st blank box, have the border of that box to turn red then exit sub. If none of them are blank, then run other code. I used to have code that would "loop" through all the controls in a form and look for blanks but I have no idea where I saved it.

BTV Excel Forum Sample.xlsm

This one should do it.
Although you would have to change BorderStyle to BorderStyleSingle for all controls first to see result.

Please Login or Register  to view this content.

Perfect as usual bakerman!! I didn't like the way the combobox looked when I changed it to Single, so I changed it back and used BackColor instead of BorderColor.

Thanks once again bakerman!!!

You're welcome and thanks for rep+.

No problem.