How do you set mutliple groups of radio buttons?
To do it without group boxes, you need to use the activeX control's option
buttons (from the control toolbox, not the forms). Once you have the buttons
placed on the sheet, in design mode (from the control toolbox), select the
option button and right-click the button, select Properties. In this window,
give the button's Groupname a unique name -- one name per group, a separate
name for each group of buttons you want to work independently. FOr example,
you have 5 buttons (button 1 thru 5). Buttons 1,2,3 all get the group name
"Bob" and buttons 4 & 5 get the group name "dwm", Now exit design mode and
you'll see the first 3 work as one group and the last 2 as another.
Bob Umlas, Excel MVP
"dwm" wrote:
I know I can group them, but how can I keep that Group Box from showing up on
my form? If I remove the Group Box, then the Cell Links all become the same
address.
|