option button ?

[Dan]

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]

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

 

[Dan]

the design mode is off (deselected) but I still can not toggle back and forth.

 

[Kevin B]

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.

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Dan]

I will try the checkbox. I am just trying to work off the linked cell
(True/False) output to do another action. Thanks.

 

[Dan]

The checkbox worked. Thanks.

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