LinkBack URL
About LinkBacks
On the attached spread sheet I am looking for a code so that if the checkbox's are ticked the corresponding cell background will change to light grey. Also a code so that when I print the checkboxes do not show up.
On the attached spread sheet I am looking for a code so that if the checkbox's are ticked the corresponding cell background will change to light grey. Also a code so that when I print the checkboxes do not show up.
You can do all of this without VBA.
For Q #1 >> Right click on the checkbox >> Format Control >> Control tab >> Cell link: >> assign a cell link
If you check the checkbox, the cell will show TRUE, and if not checked, FALSE
Now just apply conditional formatting to change the background color to light grey when the linked cell show TRUE
For Q #2 >> When you are in the Format Control dialogue box >> Properties tab >> Uncheck Print Object
HTH
Regards, Jeff
thanks for your help. Can I stop it saying TRUE or FALSE as I want to select the name and then tick the checkbox
If I'm understanding you correctly, you will use the drop down in cell B18 to select a name and then check the checkbox.
Where did you link the checkbox too? If we are speaking of the cell B18 checkbox, make the cell link to a cell out to the right, say K18.
Hello mezza89,
Why use a Checkbox combined with a DropDown? If the Cell is populated via the DropDown, you can get the desired result of shading the Cell. You do not need both, i.e: CheckBox and DropDown.
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 mezza89,
Please see the attached WorkBook to illustrate my reason.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks