Option Buttons in different groups

[bullcreel]

Lets say I have 4 Option Buttons in one group. However, I need to develop 125 of these separate groups of 4 Option Buttons. Is there a way to copy/paste so that I can have 125 separate groups of 4 Option Buttons

 

[GlennUK]

What type of Options Buttons (there are Forms and ActiveX)?

 

[bullcreel]

They are Forms

 

[GlennUK]

Well, that's a good start .. if you copy the range where the buttons and group box are, and paste elsewhere, then that does what you want. There is a downside ... this is fine if you haven't assigned a Cell Link to the options ... as that does not alter with paste of the area. If you have assigned a cell link, then you'll need to alter it in the pasted group.

 

[bullcreel]

Thank You for the feedback