| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Radio Buttons used for Yes/No questions in Excel 2007
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Radio Buttons used for Yes/No questions in Excel 2007
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Radio Buttons used for Yes/No questions in Excel 2007
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up radio buttons in excel 2007? | Excel Discussion (Misc queries) | |||
| How do I set up radio buttons and slider bars in excel? | New Users to Excel | |||
| add radio buttons to an excel document | Excel Worksheet Functions | |||
| can you put radio buttons into an excel work sheet? and how? | Excel Worksheet Functions | |||
| VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions | |||
Hybrid Mode
