Thread: option button ?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default 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