Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    control buttons (excel 2000)

    Can you set up control buttons on an excel sheet where a person can select many from a list? Right now if you select one the other is turned off. Or, is a check box the correct option to use in this case.
    Thanks..Susan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: control buttons (excel 2000)

    If you want the user to be able to select multiple options, use check boxes. If the options are mutually exclusive, use radio buttons. This is the "standard" in Windows interface design.

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: control buttons (excel 2000)

    Where do you find radio buttons?

    ..Susan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: control buttons (excel 2000)

    There are two sets of controls you can use in a worksheet: from the Forms toolbar and from the Control Toolbox. Both sets contain a check box and a radio button. See screenshot.

Posting Permissions

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