In Excel how do you make a cell a checkbox?

This is driving me nuts.

10/19/2008 10:23:00 PM

bttt

10/20/2008 12:36:01 PM

Insert - Object

10/20/2008 12:53:46 PM

do you mean you want to insert a real checkbox, like a form-object, or turn an actual cell into a checkbox?

10/20/2008 1:19:41 PM

turn a cell in to a checkbox so I can keep track of "I did or didnt to this yet"

10/20/2008 2:11:27 PM

but the check-box won't have any kind of "action" associated with it? No script running that will check the status of the checkbox or anything?
in other words, more or less the same as just putting an "x" into a cell, but just something that looks better and you can toggle off and on?

10/20/2008 2:21:27 PM

just put an X there then....

this is the same guy that mentioned a certain backpack was good (for MACs specifically)

10/20/2008 2:30:06 PM

wut?

10/20/2008 2:36:17 PM

ok, well I just got home and tried it out on my Mac Excel, and it works just like Windows Excel - go to View > Toolbars and enable the Forms toolbar.
Then you will get a little pallette of forms, including a checkbox. You can put the checkbox in wherever you want and give it a label and everything

10/20/2008 6:26:38 PM

Quote :

"but the check-box won't have any kind of "action" associated with it? No script running that will check the status of the checkbox or anything? in other words, more or less the same as just putting an "x" into a cell, but just something that looks better and you can toggle off and on? "

Pretty much.

Ill try it out wed when I go to work. Right now Im exhausted.

10/20/2008 6:28:42 PM