copying and pasting objects in VBA

[Joker4321]

Hi, I have a range of cells I want to copy which has some textboxes and check boxes in it. When I do a copy/insert cells in vba it only copies the cells and their values but not any of the boxes. Any Ideas how I can copy everything?

Here is my code:
.Range(.Cells(Origin.Row + 1, Origin.Column), .Cells(Origin.Row + 12, Origin.Column + 10)).EntireRow.Copy

.Range(.Cells(Ind.Row, 3), .Cells(Ind.Row, 3)).EntireRow.Insert Shift:=xlDown

Thanks.

 

[Joker4321]

I decided to go with the Control objects and copy them separately. Is there a simple way to clear the text within the text boxes after they are copied without keeping track of the textbox number?

Maybe an easy workaround would be to have a blank table on another sheet and copy it from there.