Option Button problem

[Paul]

I have a form which contains 4 option buttons. I would like them to be
independently checkable. To do this, I made each button a seperate group. I
can check all of them independently now, but once they are checked, they
don't seem to be able to be unchecked. How can I configure the button so that
it can be unselected by clicking on it again?

Thanks.

--
Paul

[K Dales]

Don't put the buttons in any group (frame) at all. Just use plain option
buttons with no frame. That way they act independently. A group presumes a
choice is required, and if only one button, only one choice - so you can't
deselect it.

"Paul" wrote:

> I have a form which contains 4 option buttons. I would like them to be
> independently checkable. To do this, I made each button a seperate group. I
> can check all of them independently now, but once they are checked, they
> don't seem to be able to be unchecked. How can I configure the button so that
> it can be unselected by clicking on it again?
>
> Thanks.
>
> --
> Paul

[davidm]

Paul,

If I understandard your question correctly, you are looking for a way to toggle the radio button in an "independent" OptionButton. So far as I know, Excel does not allow this. If there is a way anyone can conjure to permit this, I will be only too glad to learn.

DM