I have a form with a texbox titled "Guestname" and I would like to add the name on the sheet with the button (which I already have written down) and on a different sheet titled "Total Guests".

I would also like to do a couple more things too. On the form I have two CheckBoxes, titled "MSbox" and "ONbox". and if they are checked I would like it to fill in "MS" in column 5 and "ON" in column 6. I know I have to use the If Then statements, but I am unaware of where to put them in the code.

Here is the current code I have for the submit button:

Please Login or Register  to view this content.