View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Forms: Group Boxes and Option Buttons

Hi Kathryn,

You should use the GroupName property of the OptionButtons to specify which
"group" of option buttons each belongs to. So for your first 5, set the
GroupName property of each to something like "optgrp1", and for the second
5, set the GroupName property of each to "optgrp2". Now Excel should know
to treat them as separate groups of option buttons.

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Kathryn wrote:
I created a group box of 5 option buttons and linked them
to a specific cell with an absolute reference. I then
created another group box with 5 additional option buttons
and linked them to a different cell with a different
absolute reference. When I did this, all the links in the
option buttons from the first group changed to the second
group's links. Excel seems not to be recognizing the group
boxes and is grouping ALL the option buttons into one
group.

Any suggestions? What isn't working here?

Thank you!
Kathryn