| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create yes/ no box for selection?
Does anyone have any suggestions on how to create a selection box for yes and
no within Excel? which can only be selected one option at a time. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create yes/ no box for selection?
hi
options buttons were designed for this. the options button has a group name property that you can set to control how the option button work as a group. when you first create the button, the group property is set to the sheet name but you can change it. example. the first 2 options button(yes/no) could be set to group1 the next 2 options buttons(yes/no) could be set to group2 and so on. the above is option buttons from the control tool box(activeX). the forms options button gave a group name property but you can only set it if it is on a form. so be carefull there. regards FSt1 "Eric" wrote: Does anyone have any suggestions on how to create a selection box for yes and no within Excel? which can only be selected one option at a time. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create yes/ no box for selection?
Thank you very much for your suggestions
From Form Control Panel, I can create a group area and insert 2 checkboxs within it, one is Yes and the other is No. Could you please give me any suggestions on what to do in the next step? Do you have any suggestions? Thank you very much for any suggestions Eric "FSt1" wrote: hi options buttons were designed for this. the options button has a group name property that you can set to control how the option button work as a group. when you first create the button, the group property is set to the sheet name but you can change it. example. the first 2 options button(yes/no) could be set to group1 the next 2 options buttons(yes/no) could be set to group2 and so on. the above is option buttons from the control tool box(activeX). the forms options button gave a group name property but you can only set it if it is on a form. so be carefull there. regards FSt1 "Eric" wrote: Does anyone have any suggestions on how to create a selection box for yes and no within Excel? which can only be selected one option at a time. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create yes/ no box for selection?
Check your other post, too.
Eric wrote: Does anyone have any suggestions on how to create a selection box for yes and no within Excel? which can only be selected one option at a time. Does anyone have any suggestions? Thanks in advance for any suggestions Eric -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Possible to create multiple-selection drop-down box in Excel? | Excel Worksheet Functions | |||
| How to create a pull down menu for selection? | Excel Worksheet Functions | |||
| why does sorting large columns create errors in top selection? | Excel Worksheet Functions | |||
| How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) | |||
Linear Mode
