Transferring checked checkbox to another row

I have a row (Row 10) with has a macro. When a user enters information into row 10 and then presses a button "Add", that information gets added the last row of the worksheet, and then Row 10 is cleared for new information entry. I have been asked to put in checkboxes in a few of my cells for additional information entry.

What I require is that when a user puts in the required information and checks a checkbox/leaves a checkbox blank, and THEN presses Add, the checkbox should get copied to the last row as well, and then the checkbox in Row 10 should get cleared so that the user may enter a new record again.

The following is that code I have for copying, pasting and clearing information and it works fine. I just need to know how to incorporate the checkboxes in as well.

Please Login or Register  to view this content.