View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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