Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Duluth, Minnesota, USA
    Posts
    215
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Radio Buttons - How To? (97 SR2)

    I want to add 4 radio buttons to a spreadsheet, but have not been able to decipher the instructions on how to do so. I opened the controls toolbar, clicked the radio button icon, and placed it over the first cell. What do I do next?

    TIA, Douglas

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Radio Buttons - How To? (97 SR2)

    If you are a novice: start with the buttons on the FORMS toolbar, they are easier and more straightforward

  3. #3
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Duluth, Minnesota, USA
    Posts
    215
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radio Buttons - How To? (97 SR2)

    Normally, I would not describe myself as a novice, but I will look at the "forms" toolbar as you suggest.

    Thanks.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Radio Buttons - How To? (97 SR2)

    Select the Radio button and right click it; this provides the code and formatting dialogs.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Radio Buttons - How To? (97 SR2)

    Excel provides two types of radio buttons: on the Forms toolbar and on the Control Set toolbar. The second type is most useful in a user form, and needs coding in Visual Basic to do something useful with them. In most cases, I think the radio button from the Forms toolbar is easier to use.

    In both cases, radio buttons are not meant to operate singly. You always need to put several of the same type on your spreadsheet.

    This is how you work with radio buttons from the Forms toolbar:
    <UL><LI>If you just put a bunch of radio buttons on a spreadsheet, they form one group. Only one of them can be "on" at the same time.
    <LI>If you want to create more groups, use the Group Box from the forms toolbar. All radio buttons within one group box form a single group. Within each group, only one radio button can be "on".
    <LI>To manipulate a radio button (or group box, or any other control from the Forms toolbar), right click it. You should see a striped border around the control. Now, you can select an item from the context menu, or drag the control to another location using the border. Click without the border to stop manipulating the control.
    <LI>If the striped border is visible, you can also double click the caption to edit it, or the border to get the Format Object dialog.
    <LI>In the Format Object dialog, you can link the radio button (actually all buttons in the group) to a cell. This cell will contain a numeric value corresponding to which radio button in the group is selected (first = 1, second = 2 etc.). If you want to create a formula based on the selected radio button, refer to this cell in the formula.[/list]This is the basic idea. I hope it gets you started. Post back if you need more info.

  6. #6
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Duluth, Minnesota, USA
    Posts
    215
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radio Buttons - How To? (97 SR2)

    OK, thanks to all who replied. I have 4 radio buttons in place and working. I have two follow-up questions.

    1) Is there a way to align the 4 buttons? I would like a 2x2 array.

    2) Can I format the text to match the rest of the sheet? Right now, it is persistently black.

    Thanks again for your great help.

    Douglas

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

    Re: Radio Buttons - How To? (97 SR2)

    As mentioned in my previous reply, right-click a button to manipulate it.

    You can drag the border to position the button. If you keep the (left) Alt key down while dragging, the border will align to the cell borders. The same when resizing with the Alt key down.

    I don't think you can set any text properties. You can only set the border and background color. Sorry about that.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Radio Buttons - How To? (97 SR2)

    If you select them all
    you can align them under draw - Align or distribute. You can align them left, right, top, bottom and centered

    Steve

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radio Buttons - How To? (97 SR2)

    >>>>>>>>>>>>>>This cell will contain a numeric value corresponding to which radio button in the group is selected (first = 1, second = 2 etc.). <<<<<<<<<<

    Dear Hans,
    I would very much like to duplicate the behaviour do you describe, of putting a value in a cell with an option button group. However all my atempts seem to have failed. I have tried putting a selection of option groups directly on a spreadsheet (embedded?) And linking them to a single cell, but I get strange behaviour, the option group buttons (radio buttons) do not operate correctly.

    I have tried putting the radio buttons in a frame on the spreadsheet, and in a frame on a user form, I don't appear to be having much success. Could you point me in the right direction please.

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Radio Buttons - How To? (97 SR2)

    Got it!!!!
    I've been using the wrong option button, got it working with the "Forms" option buttons. <img src=/S/rtfm.gif border=0 alt=rtfm width=24 height=23> <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

Posting Permissions

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