VBA Form Submit to Sheet 1

I have created a VBA form the way i want it to look, it isn't yet functional as i dont know the code for when i click "submit" on the command button to drop it into the worksheet. I also need the VBA form to appear when i click Snag Form on the front page.