Userform Validation - combining code?

[snuffnchess]

Userform is adding info for up to 20 people (Potential for 8 adults labeled Adult1, adult2..... and 12 children labeled Child1, child 2....)

for each of the people, I have to run the same validations.

1. If a first name is entered there MUST be a last name entered
2. If a last name is entered there MUST be a first name entered
3. If a first name and last name is entered a DOB must be entered
4. If a first name and last name is entered then a validation yes/no box is to be checked.

I am basically looking to try and combine the macro code behind the scenes in an effort to optimize.

Example of DOB Validation code is

is there any way to do this?

Please Login or Register  to view this content.

[6StringJazzer]

First, is it important to validate as the user is filling out information, forcing them to fill it out in a specific order? If so then I would suggest managing the user interface accordingly:

Disable all controls except last name
After last name is entered, enable first name
After first name is entered, enable DOB and Yes/No boxes

The way I would do this (certainly not the only way possible) starts with renaming all of your controls to match how they're used. If you do not do this, the code is a nightmare. (I find the code in this file to be unreadable for this reason. There are maybe dozens of textboxes and you can't figure out what is what in the code.) For example,

TextBoxAdultFirst1
TextBoxAdultLast1
TextBoxAdultDOB1
ComboBoxAdultRelation1
CheckBoxAdultVerifiedYes1
CheckBoxAdultVerifiedNo1

TextBoxAdultFirst2
TextBoxAdultLast2
TextBoxAdultDOB2
ComboBoxAdultRelation2
CheckBoxAdultVerifiedYes2
CheckBoxAdultVerifiedNo2

Then you have code like this:

Please Login or Register  to view this content.

You would repeat this for each field. When you have to actually validate the contents, like DOB, you can have a validation Sub:

Please Login or Register  to view this content.