@ Luke Maciak:

Have a question. How would I form the syntax to uncheck the box if the value in another cell was than say 1?

I tried this
Code:
If Range (“G” & .Column).Value = “0” Then
Range(“sheet1″).chexkbox1.Value =”False”

and tell the script to continue to the rest of the sub?

Hey programmer,

Thanks for the code it worked. But I am facing one small problem and it is that the Linked cell shows the result only in the formula bar, whereas the Cell value doesn’t change and because of which I am unable to process whether the checkboxes are selected or not. Please help me so that I can give the Linked cell its value.

Help!!! I know this will work but I’m blowing it up! when I click on the first check box they all become checked and it only says True on the first cell. So basically they are all linked. Thanks!!!! Jane

Don’t Shoot!!!!!!
You are too awesome! I was pulling my hair out trying to figure out an easier way to do a work checklist- then I finally found this. YOU ROCK!!!!!!!!!!! THANK YOU!! :)

Just what I needed , thanks for posting the code!

We’ve tried to address this very use-case when we built Obvibase (https://www.obvibase.com). The idea that features like a column of checkboxes are so basic, and could be useful to so many people, that they should not require coding, or using a relational database and sacrificing ease-of-use of a spreadsheet.

Thank you so much for this post. It worked perfectly and saved me tons of time!!!! I tried other macros and they didn’t work. You are a genius.

Thank you very much!

This is what I needed, after deleting the first and last rows my excel ran it and it worked!
thanks from making it available

Ori Yaffe

Thanks man!
Helped me in dozens of ways, eggs-actely wot I needed.
No yoke!

Well, I was able to find a solution to my problem of disappearing checkboxes above. I have Excel 2010 but decided to try out saving it as Excel 97-2003 Workbook and that seemed to solve the issue. Or at least I think that’s what’s making it stable. Whatever it is, it’s working. If I’m going about it the wrong way, please let me know!

Thanks!