return user to UserForm if not all fields have been populated

[craigexcel]

I have a UserForm with several fields on it: 5 are 'required' and the other 6 are 'optional'. If a user doesn't enter a value for ALL of the 5 'required' fields, how do I get the code to return the user to the UserForm (with, I assume, the values they already entered, still showing)?

I have the AutoOpen code that starts things off, and then, in turn, loads the UserForm with the fields that need to be populated.

I can't figure out how to route the user back to the UserForm, to enter the 'missed' data.

 

[craigexcel]

If I understand your code correctly, if all 'required' values have not been entered, display 'error' msgbox. Otherwise, unload the userform and exit. Where does the code route me back to entering data in the userform if ALL 'required' values have not been entered?

 

[Jon von der Heyden]

Hi again

Ok so you just need to change it to CommandButton1_Click

This will keep the form open unless all mandatory fields are complete.

The Else statement:
...Unload Me

...should include your code for writing form data back to your spreadsheet. Are you ok with that bit? If you need help on that bit then please let me know where the form data should be written to (i.e. sheet name and range addresses).

 

[craigexcel]

Jon,
Looks like it works fine now. Thanks. One critical change, as you suggested, was moving the code that writes the form's data to the worksheet, after the Else statement. Thanks again!