Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkboxes vs. Option Buttons
I was attempting to use checkboxes to format different selections in my
worksheet, select one then the other option is deselected, etc. I was not able to find a way to do that using checkboxes, so, I searched here and found the Option button.. option. The issue I have with Option buttons is, that when you create multiple options in different locations the on/off option affects all option buttons in the worksheet. i.e. selection category 1, option a , b. selection category 2 option a , b. When you select option 1a the other three option buttons are blanked. How can I separate the fields into individual entities. Using Checkboxes (preferred), or option buttons. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkboxes vs. Option Buttons
If right click on the option button and select properties, and in the list of
properties locate GroupName. Assign the buttons to specific group names and when a selection is made only a button belonging to that group is deselected. -- Kevin Backmann "JW_4222" wrote: I was attempting to use checkboxes to format different selections in my worksheet, select one then the other option is deselected, etc. I was not able to find a way to do that using checkboxes, so, I searched here and found the Option button.. option. The issue I have with Option buttons is, that when you create multiple options in different locations the on/off option affects all option buttons in the worksheet. i.e. selection category 1, option a , b. selection category 2 option a , b. When you select option 1a the other three option buttons are blanked. How can I separate the fields into individual entities. Using Checkboxes (preferred), or option buttons. Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkboxes vs. Option Buttons
Yes sir, that did it !
Thank you for your help. "Kevin B" wrote: If right click on the option button and select properties, and in the list of properties locate GroupName. Assign the buttons to specific group names and when a selection is made only a button belonging to that group is deselected. -- Kevin Backmann "JW_4222" wrote: I was attempting to use checkboxes to format different selections in my worksheet, select one then the other option is deselected, etc. I was not able to find a way to do that using checkboxes, so, I searched here and found the Option button.. option. The issue I have with Option buttons is, that when you create multiple options in different locations the on/off option affects all option buttons in the worksheet. i.e. selection category 1, option a , b. selection category 2 option a , b. When you select option 1a the other three option buttons are blanked. How can I separate the fields into individual entities. Using Checkboxes (preferred), or option buttons. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Can the captions for Option Buttons be drawn from other cells ? | Excel Discussion (Misc queries) | |||
Deleting option buttons | Excel Discussion (Misc queries) | |||
Using 'Option Buttons' | Excel Discussion (Misc queries) | |||
Option Buttons in Group Box | Excel Discussion (Misc queries) |