View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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