Change the GroupName of a Form Control (not ActiveX) Option Button using VBA

[Wingersiow]

Hi,

Does anyone know how I can change the GroupName of Form Control (not ActiveX) Option Buttons using VBA.

I seem to have a problem in 2010 in that when I hide a number of grouped Option Buttons they lose their grouping when unhidden and join together with the other hidden/unhidden option buttons.

Thanks very much in advance - I'm struggling with this one

 

[sijpie]

Are you using the controls on a worksheet or in a userform? And do you mean how to change its name or the text it displays?

For boxes on the worksheet:

Option Explicit


' For groupboxes on Worksheet
' Change text groupbox displays
Sub Macro1()
'
' Macro1 Macro
'
    With ActiveSheet.GroupBoxes("Group Box 1")
        .Characters.Text = "MyGroup"
    End With
'
End Sub


' Change name of the groupbox
Sub Macro2()
'
' Macro2 Macro
'


    With ActiveSheet.GroupBoxes("Group Box 1")
        .Name = "MyGroupBox"
    End With
    
End Sub

A good way (which i did here) is to record a macro and do the action yourself. Then modify the code to make it more efficient (as i did here)

 

[Wingersiow]

Hi,

Thanks very much for your reply. What I was hoping to be able to do was change the Group a button belonged to - but it seems that isn't possible with Form Control Option Buttons so I amended my approach to get around it.

Thanks.