I have 2 checkboxes on a worksheet. The second one has no purpose unless the first one is checked. I would like for the second checkbox to be greyed out until I click on the first one. Is this possible on a worksheet (I don't use a user form)
I have 2 checkboxes on a worksheet. The second one has no purpose unless the first one is checked. I would like for the second checkbox to be greyed out until I click on the first one. Is this possible on a worksheet (I don't use a user form)
Here is how to do it with ActiveX checkboxes. Needs VBA. (I don't know how to do this with Forms checkboxes but that would also need VBA.)
Edit: If you have them both checked, then uncheck the first one, I also uncheck the second one.
Thank you...This worked as advertised however I have some Mac users of my worksheet so I've been forced to use Forms Control checkboxes.
I was able to come up with the following code for these Form Control checkboxes:
It required setting some similar code on the ThisWorkbook object in the Sub Workbook_Open() section to ensure that that behavior was in place before the checkbox was clicked on the first time.Please Login or Register to view this content.
Hello JimDandy,
The Forms Check Box controls don't have a greyed state when disabled. Instead, you could make the control visible or invisible. Copy the code below into a new VBA Module and then assign the macro to "Check Box 1". Be sure to change the names to match those on the worksheet.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
This was extremely helpful, it was just what I needed...Thank you
Hello JimDandy,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks