a Clickable check box

[shaftdx]

I was just going over some old files on our server trying to look busy at work, I came across one that had clickable check mark boxes, I have NO idea how that is done! I did not even know that was possible! can anyone help me with how to do that? I can use that function on a few other of my spreadsheets. and is there away that if you do check it something else will happen, like a row boing highlighted or something?

 

[Candyman8019]

In your Developer menu there will be an insert item on the ribbon bar. You can use that to draw a checkbox. Use the properties window to adjust properties as you see fit and you can use the .value property (true or false) to affect other functionality.

 

[shaftdx]

In your Developer menu there will be an insert item on the ribbon bar. You can use that to draw a checkbox. Use the properties window to adjust properties as you see fit and you can use the .value property (true or false) to affect other functionality.

Took awhile to figure out how to add in the developer on the ribbon but I got it now and will experiment with it. Thank You!