Multiple Radio Buttons used for Yes/No questions in Excel 2007

Discussion in 'Microsoft Excel Misc' started by mgialusis, Mar 19, 2008.

  1. mgialusis

    mgialusis Guest

    Please help! I have a document that requires 100's of Yes/No radio buttons,
    some on the same rows. I had copied/pasted all of the radio buttons into
    various cells & typed in Yes & No next to the radio buttons in the cells
    themselves (not as part of the radio button text). I thought my document was
    complete - it looks great, but I later discovered that I can only select ONE
    button on the entire sheet. If I click on another one, the first one becomes
    unchecked. I need to be able to click as many as I need checked. There does
    not need to be any intelligence or cell reference behind them.
     
    mgialusis, Mar 19, 2008
    #1
    1. Advertisements

  2. mgialusis

    Sri Guest

    If you used Radio button from Control Toolbox, then in design mode, go to
    properties, give a different group name for sets of radio buttons.

    This way they would be part of different groups and can be independantly
    checked/unchecked.

    --

    Regards

    Sri


    "mgialusis" wrote:

    > Please help! I have a document that requires 100's of Yes/No radio buttons,
    > some on the same rows. I had copied/pasted all of the radio buttons into
    > various cells & typed in Yes & No next to the radio buttons in the cells
    > themselves (not as part of the radio button text). I thought my document was
    > complete - it looks great, but I later discovered that I can only select ONE
    > button on the entire sheet. If I click on another one, the first one becomes
    > unchecked. I need to be able to click as many as I need checked. There does
    > not need to be any intelligence or cell reference behind them.
     
    Sri, Mar 19, 2008
    #2
    1. Advertisements

  3. If your buttons are from the forms toolbar then you need to add a frame
    around the connected buttons to group them.

    --
    HTH...

    Jim Thomlinson


    "Sri" wrote:

    > If you used Radio button from Control Toolbox, then in design mode, go to
    > properties, give a different group name for sets of radio buttons.
    >
    > This way they would be part of different groups and can be independantly
    > checked/unchecked.
    >
    > --
    >
    > Regards
    >
    > Sri
    >
    >
    > "mgialusis" wrote:
    >
    > > Please help! I have a document that requires 100's of Yes/No radio buttons,
    > > some on the same rows. I had copied/pasted all of the radio buttons into
    > > various cells & typed in Yes & No next to the radio buttons in the cells
    > > themselves (not as part of the radio button text). I thought my document was
    > > complete - it looks great, but I later discovered that I can only select ONE
    > > button on the entire sheet. If I click on another one, the first one becomes
    > > unchecked. I need to be able to click as many as I need checked. There does
    > > not need to be any intelligence or cell reference behind them.
     
    Jim Thomlinson, Mar 19, 2008
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page