Control Objects

[Joker4321]

Hi, I have a table with control check boxes that I copy from one sheet to another when a user needs to insert a new table. The control boxes have code in them that activates a particular textbox when they are clicked and I have made it so only one check box can be selected at a time. Is there a way to transfer the code for the check boxes when I copy and paste them from sheet to sheet? Thanks!

 

[Datsmart]

If you switch to Forms Checkboxes, the assigned code will automatically transfer when copied.
With Controls Checkboxes you will have to build some rather involved code. I wouldn't bother when the Forms Checkboxes already do what you want.

 

[Joker4321]

ok...can I have a macro within the forms check box similar to the command checkboxes such as

Private Sub CheckBox1_Click()

End Sub

or do you have to use the assign macro function?

Thanks a bunch John...you've helped a great deal

 

[Datsmart]

You are correct.
Just use the Assign Macro option. That macro code will stay with the object when you copy it.

 

[Joker4321]

Hey John,

Any ideas on how to copy and paste objects from one sheet to another without activating the sheets?

this is what I have so far

Worksheets("sheet1").Shapes.Range(Array("CheckBox1", "CheckBox2", "TextBox1", "TextBox2" _
)).Select

the above only works when sheet1 is the active sheet.