Inserting data into the next row when hitting the submit button

[jamalfried]

Hi all, I'm new to VBA and trying to figure all this macro business out. I have checkboxes and a submit button on Sheet1 of my workbook. When I hit the submit button, I want the data to appear on Sheet2. The data that appears is based on what checkboxes I clicked.

I'm having trouble making the data insert into a new row on Sheet2. Any help would be greatly appreciated!
Here's the code for my button. Don't mind the values for now, I just want to figure the code out for inserting a new row.

Please Login or Register  to view this content.

Thanks!

[ajryan88]

Hi,

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hope this helps

[Solus Rankin]

Would you like the new row at the top or the bottom of sheet 3?

[jamalfried]

Thanks ajryan88! Works great.

Solus Rankin: if I wanted to change it in the future, how would I make the new row at the bottom of Sheet 3?

[Solus Rankin]

Perhaps

Please Login or Register  to view this content.

[ajryan88]

No problems!

Please don't forget to mark this thread as solved and click on the * next to any helpful posts, just to say thanks to the poster