Group Action of CheckBox Control in Excel 2000
 

I would like to place several CheckBox Controls on an Excel 2000 Worksheet
and get them to behave as a group, where only one member of the group can
have the checked state at a time. I am using the CheckBox control from the
Conrol Toolbox Toolbar. These CheckBox Controls have a GroupName property
which I have set to the same value.

Do I need some kind of suitable container? Is there some other trick. This
is easily done with VB and other programming environments.

Any help would be appreciated.

Regards,

Dan Fisher

Group Action of CheckBox Control in Excel 2000
 

Hi Dan,

Since option buttons display this behaviour, why use these to replace the
checkboxes?

---
Regards,
Norman



"Dan Fisher" wrote in message
news:xqURe.63757$Ji4.2942@fed1read03...
I would like to place several CheckBox Controls on an Excel 2000 Worksheet
and get them to behave as a group, where only one member of the group can
have the checked state at a time. I am using the CheckBox control from the
Conrol Toolbox Toolbar. These CheckBox Controls have a GroupName property
which I have set to the same value.

Do I need some kind of suitable container? Is there some other trick.
This is easily done with VB and other programming environments.

Any help would be appreciated.

Regards,

Dan Fisher