I have set up a worksheet in Excel with numerous option buttons. My problem
is now it will only let me select 1 option button. How can I select multiple
option buttons?
Thanks,
Katie
I have set up a worksheet in Excel with numerous option buttons. My problem
is now it will only let me select 1 option button. How can I select multiple
option buttons?
Thanks,
Katie
You may not want option buttons. You can only have one option button in any
given grouping selected. You might want to use Check boxes instead.
"Katie-Baughman" wrote:
> I have set up a worksheet in Excel with numerous option buttons. My problem
> is now it will only let me select 1 option button. How can I select multiple
> option buttons?
>
> Thanks,
> Katie
If you have numerous groups of options, then you need to use the grouping
facility. If the option buttons are from the forms toolbar, just put a
groupbox arond them.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"bj" <[email protected]> wrote in message
news:[email protected]...
> You may not want option buttons. You can only have one option button in
any
> given grouping selected. You might want to use Check boxes instead.
>
> "Katie-Baughman" wrote:
>
> > I have set up a worksheet in Excel with numerous option buttons. My
problem
> > is now it will only let me select 1 option button. How can I select
multiple
> > option buttons?
> >
> > Thanks,
> > Katie
And if they're from the Control Toolbox Toolbar, you can rightclick on each of
the option buttons and show the properties. Look for GroupName.
Assign a nice unique groupname to each group of option buttons that you want,
er, grouped.
The default groupname for all the option buttons is the name of the sheet.
That's why they all work together.
Bob Phillips wrote:
>
> If you have numerous groups of options, then you need to use the grouping
> facility. If the option buttons are from the forms toolbar, just put a
> groupbox arond them.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
> "bj" <[email protected]> wrote in message
> news:[email protected]...
> > You may not want option buttons. You can only have one option button in
> any
> > given grouping selected. You might want to use Check boxes instead.
> >
> > "Katie-Baughman" wrote:
> >
> > > I have set up a worksheet in Excel with numerous option buttons. My
> problem
> > > is now it will only let me select 1 option button. How can I select
> multiple
> > > option buttons?
> > >
> > > Thanks,
> > > Katie
--
Dave Peterson
We were originally using check boxes, but when we print out the form, the
check marks did not stand out - you really couldn't see them very well. Do
you know of some way to format the check marks to make them more bold?
"bj" wrote:
> You may not want option buttons. You can only have one option button in any
> given grouping selected. You might want to use Check boxes instead.
>
> "Katie-Baughman" wrote:
>
> > I have set up a worksheet in Excel with numerous option buttons. My problem
> > is now it will only let me select 1 option button. How can I select multiple
> > option buttons?
> >
> > Thanks,
> > Katie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks