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.

Hi Mike,

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

regards,

James

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

mike

" wrote:

Hi Mike,

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

regards,

James

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

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=38475

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

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


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