Inserting a checkbox

[PT]

WinXP Home, Excel 2003

How to do it? I tried Insert | Symbol. No luck.

Then, I opened the Control Toolbar, and found the checkbox control.

But I couldn't figure out how to insert the box into a cell, such that the
user could click on the resulting box to check or uncheck the box.

Pleasee advise.

 

[Jacob Skaria]

Like drop down you cannot have a checkbox in a cell. From taskbar, Toolbox
drag a checkbox and size the checkbox so that it sits right on the cell and
set a property of the checkbox that so as to resize and move with the cell.

If this post helps click Yes

 

[JasonS]

Jacob is correct about not being able to place a checkbox INSIDE a cell...

by simply adding a checkbox to a worksheet, all you'll have is a pretty
little checkbox. however, whether or not that box has been checked will not
be stored anywhere. If you want a value to be stored in another cell
(True=checked, False/blank= unchecked/never checked) then you have to r-click
on the checkbox and you should see a "Link Cell" box. enter the cell
reference of your choice and hit OK. now if you go and check the box, the
"TRUE" should show up in the cell that you just linked to the checkbox.
now... to take a step further you can add an IF function to your worksheet
that will look at your linked cell...
Ex:
a1 "contains" checkbox (another we know that the checkbox is not actually
INSIDE the cell)
b1 is linked to the checkbox
c1 has the following: IF(b1=TRUE,"CHECKED","NOT CHECKED")
this of this method for creating an order form. on one sheet, a customer
can check the items that they want to purchase. One another sheet they values
for the boxes would be stored and you could have IF functions that will input
the cost of that item if true shows up, and 0 if false shows up.


i took this a bit further than i think you were looking for, but who knows
if goes this far with a checkbox could actually make it easier for you.

*remember to rate