Revision history [back]

Assuming you are referring to an Excel sheet, follow these steps to duplicate a row and ensure the checkbox and its code are also copied over:

Select the row that you want to duplicate.
Right-click on the row number and select "Copy".
Right-click on the row number where you want the duplicate to appear and select "Insert Copied Cells".
Make sure that the "Shift cells right" option is selected and click OK.
You should now see a duplicated row with all the cells from the original row copied over.
If there was a checkbox in the original row, you should see it in the duplicated row as well. If the checkbox is not checked, click on it to check it.
If there was any code associated with the checkbox, it should be copied over as well. You can check this by right-clicking on the checkbox and selecting "Format Control". In the "Control" tab, you should see the same code as in the original checkbox.

That's it! You have duplicated a row and ensured that the checkbox and its code are also copied over.