![]() |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com