Best Placement of Checkbox on Multipage Userform - Excel VBA

**eemiller1997** · 01-08-2013, 12:10 PM

Here is the background....
I have a multi-page userform with a tab called Intvw Info & Team and a tab called Candidate.

On the Intvw Info & Team tab, user will enter an interview team of 3 to 8 names and press Enter to store that data onto a worksheet called JobIntvwData.

On the Candidate tab, user will enter information for a candidate and press add/update to store that data onto a worksheet called CandidateData. User has the ability to continue to add additional Candidates on the Candidate tab using the same method, over and over and over again.

There is a question on the Candidate tab that allows the user to answer if the candidate will be using the same interview team previously entered on the Intvw Info and Team tab. If not, they are allowed to make changes for each candidate's interview team. This is stored on the CandidateData worksheet.

Here is the situation....
Sometimes - in fact, most times, we do not know the team until later. So, the user will enter all of the information for each candidate to approve them for interview. Then, we will save the multipage userform and forget about it. Then, sometime later - maybe even a few days or weeks, user will re-open that multipage userform with the intent to only enter the interview team information and print everything out.

In this case, I do not want the user to have to enter the team under the intvw Info and Team tab and then go into each candidate and select yes or no for if the same team will be used, and then add/update each and every single candidate. That would be cumbersome.

On the Intvw Info & Team tab, if the same team will be used for each candidate, then I want the user to be able to checkmark a checkbox indicating the interview team will be used for all candidates.

Here is the question....
How is the best way to do this?

Would it be best to code that checkbox to go to the....

JobIntvwData worksheet where the Intvw Info and Team info is stored, as long as the code somehow doesn't conflict and over-ride an answer given on the Candidate tab, or maybe that doesn't matter.
CandidateData worksheet where the candidate info is stored, but then I would have to code it to add it to each candidate that has been entered and all possible future candidates entered.