ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   option button ? (https://www.excelbanter.com/excel-discussion-misc-queries/170858-option-button.html)

dan

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

Kevin B

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


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


Kevin B

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


Rick Rothstein \(MVP - VB\)

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



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




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