Hello everyone. I have an interesting project I am working on, and would appreciate some help.

1. I would like to write VBA code which would include a userform and on the form would be a check list, the checklist would inlcude all of the groups participating in the FIFA WC, e.g GROUP A, GROUP B and so on. The user will be propmted to select a group (or groups) and press ok when they are finished.

2. After selecting (or checking) which groups they want (possibly more than one), another user form will pop up and will list the teams that are in each Group they selected. The userform in (1.) should be gone at this point. For instance if they select GROUP A, there will be a part of the userform which says GROUP A and below it will be a check list of the teams which are competing in GROUP A, and so forth. They will be prompted to "select teams" and then press ok.

3. Aftern checking which teams they want a workbook will open, and in the workbook will be several worksheets where each worksheet has been named ( and thus corresponding too) a team that was selected in (2.). Within the worksheet will be the names of the players.

Now all of the data for this will be stored in one "Master spread sheet"; which will have one worksheet named "Groups" and in it [using named ranges "GROUP A" etc,] will be the teams organized by groups. There are five groups and five teams per group. There will also be 25 worksheets each one named after a team where the players names will be kept.