All thanks for your help in advance. I am trying to limit the number of checkboxes a user can select on a worksheet. I have 109 checkboxes total and of those I would like there is a group of 10 (Group1) and within those 10 I want a user to be able to select up to 4.
The checkboxes are not on a USERFORM. They are activeX boxes directly on a worksheet. I have tried many ways and cannot figure this out.
Any help would be be greatly appreciated.
I can think of two ways to do this.
1) Link each checkbox to a cell, then have a cell with an error message that uses a formula to implement the rule you want to enforce. However, this will not prevent them from clicking a box, just notify them if they click too many.
2) Use macros
To get a more detailed solution that is specific to your problem please attach your file. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Thanks for responding 6StringJazzer.
I have attached a file that has the checkboxes. Out of the 8 I would like a user to be able to select only up to three options.
Since you already have code, let's use a code solution.
You have removed worksheets so now when I try to save the file, Workbook_BeforeSave runs but results in an error because it refers to sheets that don't exist. I had to exit that code to be able to save the file.
You have existing code that, when a user checks a box, all other boxes become unchecked. What you are asking for requires scrapping all of that. I have replaced it with something else.
The new code adds a Sub that has the last checked box as its parameter. It counts the number of checked boxes. If it is more than 3, then it unchecks the last checked box. Each Click event handler calls this Sub if the box is checked.
6StringJazzer thanks so much! You're awesome, exactly what I needed!
You're welcome! Thanks for the rep, and thanks for marking your thread Solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks