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
Bookmarks