The error is because you've changed the name of from CandidateTemp to CandidateForm.

There is no code stored under any worksheet.

There is not need for columns for the ***** answers.

They are based on the values of certain controls.

If we write those values to the worksheet then we can deal with it when we are actually filling out the form with candidate data.

Can you please look at the workbook I just posted?