Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have about 20 check boxes on sheet1 of a spreadsheet from the Controls tool
box. 5 of them are loners and should not be touched in regard to the remaining 15. The 15 are Very good, Good, Ok, Bad, Very Bad answers... Q1 A1,2,3,4,5 Q2 A1,2,3,4,5 Q3 A1,2,3,4,5 I want to be able be click an answer on Q1 and have the code untick all the other answers for Q1 but not Q2 or Q3, then tick any one of the answers on Q2 and have the code untick all the other boxes on Q2 and same for Q3. If however the user changes their mind on Q? the code should untick all the other answers on that Q. I have (at work) some working code but checking through it on Debug, step into it jumps backwards and forwards through each of the checkbox?_click() subs. Can someone suggest some code to do the above please? Thanks Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clear check boxes? | Excel Programming | |||
Clear check boxes? | Excel Programming | |||
Clear check boxes? | Excel Programming | |||
Clear All Check Boxes | Excel Programming | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) |