Trying to get checkbox to activate different worksheet

Do you mean

Please Login or Register  to view this content.

I can't see the point in forcing users to close the form using your button, personally I find it annoying when this happens

Hi Nemo5;

Here's a file that should get you started in the right direction.
I changed the checkboxes to radio buttons. That way only 1 can be checked at a time. With checkboxes, they could both be checked.

Here's a suggestion. Make the "Print Form" button disabled to start. When the info has been added to a sheet, then enable it.

Another suggestion. Name the cells in the sheets. Example name D6 "Name".
Then in CmdAdd_Click you would ".Range("Name").Value = Me.txtName.Value". That way when you move "Name" to some other spot on the sheet, you don't have to remember to change the address in your form.
BTW, "Me.txtName" is not necessary "txtName" will work. You'll see that I use "Opt_Personal", not "Me.Opt_Personal"

Edit:
I just noticed the title to this thread. Do you really want to "Activate" the sheets and hide the form?