+ Reply to Thread
Results 1 to 8 of 8

How do I let only one box be chosen when there are several?

  1. #1
    alruslavage
    Guest

    How do I let only one box be chosen when there are several?

    I've put several 'check' boxes in a sheet. I want to allow only one to be
    chosen. Can anyone help?

  2. #2
    Nick
    Guest

    Re: How do I let only one box be chosen when there are several?

    Don't use checkboxes use option buttons instead as only one can be selected
    at a time.

    Nick

    "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    > I've put several 'check' boxes in a sheet. I want to allow only one to be
    > chosen. Can anyone help?




  3. #3
    Vasant Nanavati
    Guest

    Re: How do I let only one box be chosen when there are several?

    Use radio buttons instead; it's better design.

    --

    Vasant

    "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    > I've put several 'check' boxes in a sheet. I want to allow only one to be
    > chosen. Can anyone help?




  4. #4
    alruslavage
    Guest

    Re: How do I let only one box be chosen when there are several?

    Looked up 'radio' buttons and cannot find it's functionality and how-to.
    Where do I find this info?

    "Vasant Nanavati" wrote:

    > Use radio buttons instead; it's better design.
    >
    > --
    >
    > Vasant
    >
    > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    > news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    > > I've put several 'check' boxes in a sheet. I want to allow only one to be
    > > chosen. Can anyone help?

    >
    >
    >


  5. #5
    Vasant Nanavati
    Guest

    Re: How do I let only one box be chosen when there are several?

    Sorry, should have said "option buttons."

    --

    Vasant

    "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    news:1C72E7E3-C7DB-4991-A640-4C76019FD990@microsoft.com...
    > Looked up 'radio' buttons and cannot find it's functionality and how-to.
    > Where do I find this info?
    >
    > "Vasant Nanavati" wrote:
    >
    > > Use radio buttons instead; it's better design.
    > >
    > > --
    > >
    > > Vasant
    > >
    > > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    > > news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    > > > I've put several 'check' boxes in a sheet. I want to allow only one

    to be
    > > > chosen. Can anyone help?

    > >
    > >
    > >




  6. #6
    Nick
    Guest

    Re: How do I let only one box be chosen when there are several?

    There are two types in excel 2000
    Either on the Forms tool bar or the Control Toolbox toolbar.
    Right click the current menubar and select the toolbars from there. Or
    View - Toolbars.

    The Forms option button and the Control option button are different and are
    implemented differently but work the same, i.e only one can be selected at a
    time.
    The Control option button has more functionality through VBA.

    Nick


    "Vasant Nanavati" <vasantn *AT* aol *DOT* com> wrote in message
    news:%23NH90%23WVFHA.1404@TK2MSFTNGP09.phx.gbl...
    > Sorry, should have said "option buttons."
    >
    > --
    >
    > Vasant
    >
    > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    > news:1C72E7E3-C7DB-4991-A640-4C76019FD990@microsoft.com...
    >> Looked up 'radio' buttons and cannot find it's functionality and how-to.
    >> Where do I find this info?
    >>
    >> "Vasant Nanavati" wrote:
    >>
    >> > Use radio buttons instead; it's better design.
    >> >
    >> > --
    >> >
    >> > Vasant
    >> >
    >> > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    >> > news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    >> > > I've put several 'check' boxes in a sheet. I want to allow only one

    > to be
    >> > > chosen. Can anyone help?
    >> >
    >> >
    >> >

    >
    >




  7. #7
    alruslavage
    Guest

    Re: How do I let only one box be chosen when there are several?

    do you mean ActiveX control? When I do a search on option buttons, it comes
    up with ActiveX and with manipulating the controls of the page. Nothing
    about check boxes.

    "Vasant Nanavati" wrote:

    > Sorry, should have said "option buttons."
    >
    > --
    >
    > Vasant
    >
    > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    > news:1C72E7E3-C7DB-4991-A640-4C76019FD990@microsoft.com...
    > > Looked up 'radio' buttons and cannot find it's functionality and how-to.
    > > Where do I find this info?
    > >
    > > "Vasant Nanavati" wrote:
    > >
    > > > Use radio buttons instead; it's better design.
    > > >
    > > > --
    > > >
    > > > Vasant
    > > >
    > > > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    > > > news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    > > > > I've put several 'check' boxes in a sheet. I want to allow only one

    > to be
    > > > > chosen. Can anyone help?
    > > >
    > > >
    > > >

    >
    >
    >


  8. #8
    Nick
    Guest

    Re: How do I let only one box be chosen when there are several?

    The controls on the Control Toolbpx toolbar are ActiveX Controls.
    In Excel help serach for 'Types of Controls" and you should see two help
    topics. One about Form controls and the other about ActiveX controls.

    Nick

    "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    news:2A30D4E1-E9D6-4BCF-82D0-E86EAF70180A@microsoft.com...
    > do you mean ActiveX control? When I do a search on option buttons, it
    > comes
    > up with ActiveX and with manipulating the controls of the page. Nothing
    > about check boxes.
    >
    > "Vasant Nanavati" wrote:
    >
    >> Sorry, should have said "option buttons."
    >>
    >> --
    >>
    >> Vasant
    >>
    >> "alruslavage" <alruslavage@discussions.microsoft.com> wrote in message
    >> news:1C72E7E3-C7DB-4991-A640-4C76019FD990@microsoft.com...
    >> > Looked up 'radio' buttons and cannot find it's functionality and
    >> > how-to.
    >> > Where do I find this info?
    >> >
    >> > "Vasant Nanavati" wrote:
    >> >
    >> > > Use radio buttons instead; it's better design.
    >> > >
    >> > > --
    >> > >
    >> > > Vasant
    >> > >
    >> > > "alruslavage" <alruslavage@discussions.microsoft.com> wrote in
    >> > > message
    >> > > news:C6D77A6C-591B-41DB-AC54-D0968CD9981B@microsoft.com...
    >> > > > I've put several 'check' boxes in a sheet. I want to allow only
    >> > > > one

    >> to be
    >> > > > chosen. Can anyone help?
    >> > >
    >> > >
    >> > >

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1