Results 1 to 11 of 11
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Option Buttons (Excel 97 SR-2)

    I have added a group box with 4 option buttons inside. This works fine. I have linked these buttons to one cell. When I pick an option button the number for that button appears in the linked cell. I thought it might be the "print object" in the format control but it happens where this is checked or not. What am I doing wrong?

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

    Re: Option Buttons (Excel 97 SR-2)

    I'm sorry, but I don't understand. What "happens where this is checked or not"?

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Buttons (Excel 97 SR-2)

    Sorry, I'll try to be a little clearer. Each option button has a value (this may not be the correct term), the first one is 1, the second is 2, and so on. When any of the option buttons are checked, the corresponding value shows in the linked cell. So if I check the fourth option button, a 4 shows in the linked cell.

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

    Re: Option Buttons (Excel 97 SR-2)

    Still not clear to me, sorry. Is this what happens, or what you want to happen?

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Buttons (Excel 97 SR-2)

    This is not what I want to happen. All I want is the option button to be checked. I have linked to a cell so I use this in a formula. I will try to attach an example of what I am talking about.

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

    Re: Option Buttons (Excel 97 SR-2)

    I am completely lost. You don't want a number to appear in the linked cell, yet you want to use it in a formula. That is contradictory. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  7. #7
    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: Option Buttons (Excel 97 SR-2)

    What do you want to happen?

    Steve

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

    Re: Option Buttons (Excel 97 SR-2)

    I also don't understand what it is that you don't want to happen, but if you do not want cell A1 linked to the buttons, select any one of the button controls and delete the link reference (right click ans select Format Control, highlight the Cell Link reference in the Control tab, and press delete), then delete the contents of cell A1, and your link will be gone.
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Option Buttons (Excel 97 SR-2)

    Hi,
    If I understand you correctly, you want the functionality of the linked cell (i.e. to be able to use the value of the option buttons in a formula) but you don't want to see the value in the cell (e.g. for printing purposes)? If so, I would suggest you either use a cell in a hidden column or format the font of the linked cell white.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Option Buttons (Excel 97 SR-2)

    If you don't want the cell value to change when you activate the option button, do not link the control to the worksheet. ie, dont assign a value to the linked cell!
    Regards,
    Rudi

  11. #11
    Lounger
    Join Date
    Jan 2001
    Location
    New Orleans, Louisiana
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Buttons (Excel 97 SR-2)

    This is exactly what I am trying to do. Sorry my explanation was not clear. Thanks to everyone for their help.

Posting Permissions

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