View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
augustus augustus is offline
external usenet poster
 
Posts: 49
Default ActiveX Option Buttons all act as one group

Try this:
Select option buttons that mean to form a group, then right-click and click
Properties, then change GroupName properties to something unique. Do this
again for the other two sections.

Also, when you say "They are arranged into three sections on a form."
someone might interpret as userform. ( i have made this mistake in the past.)

Hope this work.


"quartz" wrote:

I have several option buttons on a sheet entered from the "Control Toolbox"
(ActiveX controls). They are arranged into three sections on a form. The
problem is, when I click an option button in one cluster, ALL other option
buttons in all clusters get blanked.

How can I group the option buttons so that they correspond to only other
buttons in their cluster?

Thanks much in advance.