| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option button group name
How can I change the group name of an option button WITHIN A MACRO? I've
tried ActiveSheet.Shapes("OptionButton1").GroupName = "test" but I receive an error message "Object doesn't support this property or method." I can effectively change the name of the button by "ActiveSheet.Shapes("OptionButton1").Name = "test" but I need to change the group name. Thanks in advance! -Chad |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option button group name
ActiveSheet.OleObjects("OptionButton1").Object.Gro upName = "Test"
-- Regards, Tom Ogilvy "Chad" wrote in message ... How can I change the group name of an option button WITHIN A MACRO? I've tried ActiveSheet.Shapes("OptionButton1").GroupName = "test" but I receive an error message "Object doesn't support this property or method." I can effectively change the name of the button by "ActiveSheet.Shapes("OptionButton1").Name = "test" but I need to change the group name. Thanks in advance! -Chad |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option button group name
Thanks Tom! Perfect!
"Tom Ogilvy" wrote: ActiveSheet.OleObjects("OptionButton1").Object.Gro upName = "Test" -- Regards, Tom Ogilvy "Chad" wrote in message ... How can I change the group name of an option button WITHIN A MACRO? I've tried ActiveSheet.Shapes("OptionButton1").GroupName = "test" but I receive an error message "Object doesn't support this property or method." I can effectively change the name of the button by "ActiveSheet.Shapes("OptionButton1").Name = "test" but I need to change the group name. Thanks in advance! -Chad |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option button group name
How about just:
ActiveSheet.OptionButton1.GroupName = "test" or ActiveSheet.Shapes("optionbutton1").OLEFormat.Obje ct.Object.GroupName = "test" or ActiveSheet.OLEObjects("Optionbutton1").Object.Gro upName = "test" I think I like the top one! Chad wrote: How can I change the group name of an option button WITHIN A MACRO? I've tried ActiveSheet.Shapes("OptionButton1").GroupName = "test" but I receive an error message "Object doesn't support this property or method." I can effectively change the name of the button by "ActiveSheet.Shapes("OptionButton1").Name = "test" but I need to change the group name. Thanks in advance! -Chad -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option button group name
Thanks. These are all terrific!
"Dave Peterson" wrote: How about just: ActiveSheet.OptionButton1.GroupName = "test" or ActiveSheet.Shapes("optionbutton1").OLEFormat.Obje ct.Object.GroupName = "test" or ActiveSheet.OLEObjects("Optionbutton1").Object.Gro upName = "test" I think I like the top one! Chad wrote: How can I change the group name of an option button WITHIN A MACRO? I've tried ActiveSheet.Shapes("OptionButton1").GroupName = "test" but I receive an error message "Object doesn't support this property or method." I can effectively change the name of the button by "ActiveSheet.Shapes("OptionButton1").Name = "test" but I need to change the group name. Thanks in advance! -Chad -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Group in excel | Excel Discussion (Misc queries) | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
| Option Buttons in Group Box | Excel Discussion (Misc queries) | |||
| Option group and Combobox | Excel Programming | |||
Linear Mode
