Hello -
I would like to use VBA to change the worksheet tab color based on ActiveX checkbox values. I have 10 ActiveX checkboxes on one worksheet. When one of the boxes is checked, I want the worksheet tab color to change to yellow. When all are checked, I would like the worksheet tab to change to green. When none are checked, I would like the worksheet tab to remain red.
What is the best way to do this?
Thank you!
Last edited by penny; 01-19-2015 at 11:29 AM.
Please Login or Register to view this content.
David
(*) Reputation points appreciated.
Thank you for the help, Tinbendr. I am unable to get this code to work. I have copied and pasted it into the code of the worksheet. Does it have anything to do with my checkboxes being labeled as "CheckBox1", "CheckBox2", etc.?
Go to Developer tab. Click Design. Double click on each button. This will generate a click event. In each event type the name of the macro. Turn design mode off. Then as you click each checkbox, the code will run and change to tab color as required. I thought it didn't work at first either, but you have to get off the tab to really see the color.
Thank you! I added the macro to each click event. It still wasn't working. I realized I had all of the checkboxes grouped. Once I removed the grouping, the code worked great.
For checkboxes in Groups
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks