| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Planilha action control | New Users to Excel | |||
| Action Event, CheckBox, Add Row and Textbox | Excel Discussion (Misc queries) | |||
| HOW DO I GIVE A CONTROL TOOLBOX CHECKBOX A VALUE IN EXCEL? | Excel Worksheet Functions | |||
| how to delete or remove checkbox form control in Excel? | Excel Discussion (Misc queries) | |||
| Programmatically set Excel 97 Control Toobar Checkbox object & container name | Excel Programming | |||
Linear Mode
