Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
I added a option button from the control toolbox. Dumb question. How do I get
the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
Sounds like you are still in design mode. On the Control Toolbox toolbar is
a button with a pencil/triangle/ruler, click this button to toggle design mode off and see if that doesn't correct the problem -- Kevin Backmann "Dan" wrote: I added a option button from the control toolbox. Dumb question. How do I get the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
the design mode is off (deselected) but I still can not toggle back and forth.
"Kevin B" wrote: Sounds like you are still in design mode. On the Control Toolbox toolbar is a button with a pencil/triangle/ruler, click this button to toggle design mode off and see if that doesn't correct the problem -- Kevin Backmann "Dan" wrote: I added a option button from the control toolbox. Dumb question. How do I get the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
You have to have at least one other option button to toggle on/off, which
makes sense as option buttons are used to select mutually exclusive selections. Try a check box instead. -- Kevin Backmann "Dan" wrote: the design mode is off (deselected) but I still can not toggle back and forth. "Kevin B" wrote: Sounds like you are still in design mode. On the Control Toolbox toolbar is a button with a pencil/triangle/ruler, click this button to toggle design mode off and see if that doesn't correct the problem -- Kevin Backmann "Dan" wrote: I added a option button from the control toolbox. Dumb question. How do I get the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
If I understand what you are trying to do, then that is not how an
OptionButton works. There needs to be two or more OptionButtons (in a group) in order to use them... click one and all other OptionButtons in the group are unselected... that is, only one OptionButton in a group can be selected at a time. It sounds like you want a CheckBox, not an OptionButton. Rick the design mode is off (deselected) but I still can not toggle back and forth. "Kevin B" wrote: Sounds like you are still in design mode. On the Control Toolbox toolbar is a button with a pencil/triangle/ruler, click this button to toggle design mode off and see if that doesn't correct the problem -- Kevin Backmann "Dan" wrote: I added a option button from the control toolbox. Dumb question. How do I get the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
I will try the checkbox. I am just trying to work off the linked cell
(True/False) output to do another action. Thanks. "Rick Rothstein (MVP - VB)" wrote: If I understand what you are trying to do, then that is not how an OptionButton works. There needs to be two or more OptionButtons (in a group) in order to use them... click one and all other OptionButtons in the group are unselected... that is, only one OptionButton in a group can be selected at a time. It sounds like you want a CheckBox, not an OptionButton. Rick the design mode is off (deselected) but I still can not toggle back and forth. "Kevin B" wrote: Sounds like you are still in design mode. On the Control Toolbox toolbar is a button with a pencil/triangle/ruler, click this button to toggle design mode off and see if that doesn't correct the problem -- Kevin Backmann "Dan" wrote: I added a option button from the control toolbox. Dumb question. How do I get the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
option button ?
The checkbox worked. Thanks.
"Rick Rothstein (MVP - VB)" wrote: If I understand what you are trying to do, then that is not how an OptionButton works. There needs to be two or more OptionButtons (in a group) in order to use them... click one and all other OptionButtons in the group are unselected... that is, only one OptionButton in a group can be selected at a time. It sounds like you want a CheckBox, not an OptionButton. Rick the design mode is off (deselected) but I still can not toggle back and forth. "Kevin B" wrote: Sounds like you are still in design mode. On the Control Toolbox toolbar is a button with a pencil/triangle/ruler, click this button to toggle design mode off and see if that doesn't correct the problem -- Kevin Backmann "Dan" wrote: I added a option button from the control toolbox. Dumb question. How do I get the button to click off when I deselct it? Right now when I select it I can't deselect it. Thanks in advance. Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Button | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Getting value of Option button | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) |