Is there a way I can get one checkbox to essentially disable all others? I have a list of checkboxes with one saying "None" which initialises on True. Can I have it set to false once any other checkbox is used but then also return to true when all other boxes are unchecked?
Hello FirstClassScamp,
Welcome to the Forum!
Actually, the above should be the other way round. When a CheckBox is "Ticked" its value is True and, when not its value is False....but then also return to true when all other boxes are unchecked?
It would be much easier for us to maybe assist you, if you can show us what you have thus far.
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello, I think I've attached the workbook. Essentially I want the group of checkboxes to open with one already ticked, but then as soon as any other are ticked that would then be unticked. Similarly if that first one is then ticked the others would be all unticked. Almost like two options buttons (yes and no), but instead of a No button it would be a list of options.
Any help would be very appreciated.
Chris
A potential different approach would be a question with two options. Then when the second option is selected the list of checkboxes is made available to the user. Is that possible?
Is there any reason why you do not use option buttons instead?
Is there a way to use option buttons to then allow a user to access more detail? If they select no then nothing more would display, but if they select yes then options would appear for them to select from?
Hello FirstClassScamp,
I have made a few changes to your code and userform. You now have two option buttons to select allergens or not. I have also added an extra procedure to your userform code as shown below.
Please try the attached sample Workbook.
Please Login or Register to view this content.
Regards.
Last edited by Winon; 08-10-2019 at 06:48 PM. Reason: Provided Code to Adjust width of Column E to Text Lenght
That's excellent! Thank you so much for your help!
Thank you for the feedback, FirstClassScamp,
Glad I could help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks