option button ?

D

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
 
K

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
 
K

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.
 
R

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
 
D

Dan

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

Dan

The checkbox worked. Thanks.

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Top