Thank you for pointing out you had uploaded something. I've looked at what you've uploaded. Testing the form, the user selects 'NewCandidate'? Is that how? When I tried that, it gave the new candidate information already entered into the UserForm. Also, when I tried to change the name for New Candidate and information, it didn't add my new candidate to the list. When I tried to click, Add/Update button, it didn't provide anything, either.

With regard to the columns for the ***** answers, I am confused by this, but will wait to see this in action to see what you mean. As long as the user can say Candidate Angie Johnson needs relocation and Candidate John Doe doesn't and the proper answers are placed in the worksheet along with the corresponding ***** in the correct cells for the appropriate candidate, I'm happy