Allow ONE checkbox selected in a group

[Mike K]

I have inherited a spreadsheet with several userforms which have groups of
checkboxes and would like to know if I can make them only have one selected
at a time. They are later copied to another sheet and if you have more than
one checked, sometimes you don't know it until you get to the very end.

[mangesh_yadav]

Select all checkboxes, right click to view properties, and enter a group name.

Mangesh

[[email protected]]

Hi Mike,

One way would be to change them to option boxes with in a frame.

regards,

James

[Mike K]

Thanks, Im doing that now. Tedious, but it works.

mike

"[email protected]" wrote:

> Hi Mike,
>
> One way would be to change them to option boxes with in a frame.
>
> regards,
>
> James
>
>

[Mike K]

Mangesh,
I tried your method and I can still select more than one from
the group. I recoded the sheet with objectboxs and got the disired results.
Am I missing something else?

Mike

"mangesh_yadav" wrote:

>
> Select all checkboxes, right click to view properties, and enter a group
> name.
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=384755
>
>

[mangesh_yadav]

Hi Mike,

Apologies. You are not missing something, but its me who missed somthing. Somehow I read the checkbox as option button, and thought that you had them in different groups.

Please ignore my post, and convert all your checkboxes to option buttons.

Mangesh