samedi 5 juin 2021

Automatically check a checkbox when a different checkbox is checked excel

So I just discovered the developer tab on excel and am having trouble trying to work with checkboxes.

I have a sheet with locations that can be checked twice enter image description here

To keep track of some things, I have the usual linked cell next to the checkbox to say TRUE or FALSE to count them, as well as some cosmetic conditional formatting.

Now, what I want to do is: whenever you check the checkbox on the right, the checkbox on the left should be checked as well, but not the opposite.

I've been reading and reading but can't find a solution to this specifically. What I found that was most similar was this, but it didn't work with me (trying to change FALSE to TRUE) link to stackoverflow

Thank you in advance to anyone who has any idea how to do this, or has a link to an already answered question i could have missed!

PS: I know absolutely nothing about VBA, it's the first time I've used it. Also this is just a project on the side for a checklist, nothing serious but I figured I could make it pretty. I do know a bit of C# but I doubt it's helping.




Aucun commentaire:

Enregistrer un commentaire