Copy and Paste Several checkboxes and code

[jeffmoseler]

I have a bunch of check boxes in a sheet that, when checked, add a date to a particular cell. I then created a new Sheet and copied the entire sheet into a new one. I need to copy the checkboxes over as well and have them add the date to the same cell in the new Sheet. Is this possible?

 

[Colin Legg]

Hi,

Instead of adding a new worksheet and then copying + pasting, you can use the worksheets copy method to directly create a copy of the worksheet, eg:

'we want to copy "Sheet2" 
Worksheets("Sheet2").Copy after:=Worksheets(Worksheets.Count)

Not sure what you mean by adding dates, but the functionality of the checkboxes will be identical to that of the original sheet.


If you aren't doing this with VBA, this is the same functionality as right-clicking on the worksheet's tab, choosing Move or Copy..., and then ticking the "create a copy" checkbox.

Hope that helps...