How to make a cell a generic checkbox

This is (almost!) exactly what i've been looking for...
http://www.excelforum.com/showthread.php?t=576315

Please Login or Register  to view this content.

All i need help with now, is how i get this to work just in one column or a range of cells (eg A3:A20)?

Any help would be greatly appreciated!
Thanks

Try This

Please Login or Register  to view this content.

Double click to get an X,
double click on an X to clear it

Originally Posted by Cheeba

Thanks Davesexcel!
That works perfectly. Just what i was after.
If only everything in life could be sorted out so quickly!

Again, thanks!

Thanks for the feed back,
I have always liked that way of creating "X" marks, if you change the code to "a" instead of "r" you will get a check mark