I need some help in resetting checkboxes. I have a button that resets cells, but I also want several checkboxes to be reset to unchecked when the button is pressed. Is there some code I can add to the button to make this happen?
Thanks in advance.
I need some help in resetting checkboxes. I have a button that resets cells, but I also want several checkboxes to be reset to unchecked when the button is pressed. Is there some code I can add to the button to make this happen?
Thanks in advance.
Hello Mhart210,
These code examples work with the Forms CheckBoxes. Use the constants xlOn and xlOff rather than True or False. Substitute your CheckBox names into the code below.
Examples of Checking and UnChecking:
Example of Clearing All CheckBoxes on the Active Sheet:![]()
Please Login or Register to view this content.
Sincerely,![]()
Please Login or Register to view this content.
Leith Ross
Thank you so much. It worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks