Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple checkbox selection
I have an excel sheet with many Yes/No, Good/Abnormal checkboxes. The list is
long. I want to have this checksheet have a feature to select all Yes, or Select all no, or select all good, select all abnormal, to avoid the operator having to check all if good/bad/ or the other. Any suggestions |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple checkbox selection
If your checkboxes are from the Forms toolbar you can change all values in
one go like this ActiveSheet.CheckBoxes.Value = xlOff ' xlOn Your question is ambiguous though, not sure if something like the above is what you want or if you want to change certain checkboxes. Regards, Peter T "Matt" wrote in message ... I have an excel sheet with many Yes/No, Good/Abnormal checkboxes. The list is long. I want to have this checksheet have a feature to select all Yes, or Select all no, or select all good, select all abnormal, to avoid the operator having to check all if good/bad/ or the other. Any suggestions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow selection of only 1 checkbox | Excel Discussion (Misc queries) | |||
copy checkbox to multiple cells? | Excel Programming | |||
Updating multiple worksheets dependent on checkbox selection | Excel Programming | |||
CheckBox Selection | Excel Programming | |||
CheckBox and Data Selection | Excel Programming |