Adding a check box

[Wyatt12]

How do I add a check box to a cell? I have two cells, one which would be a yes and the other would be a no. I want to add a box that if you click on it a check would be added and by clicking on it twice it would be removed. I'm not sure if I would just add a text box or what.

Thanks for any assistance!

Wyatt12

[GuruWannaB]

You can do this one of two ways.

View -> Toolbars -> and either Forms or Control Toolbox (which I prefer because you can manipulate the input)

Both toolbars have a checkbox, although there are some differences between the two - but that is another question =)

I found this webpage that might help you as well - http://www.infopackets.com/news/caro...s_ms_excel.htm

[shg]

I'd suggest Marlett checkboxes. Unlike checkboxes from the Forms toolbar or control toolbox, they're on the same layer as the cells, which simplifies things.

There are ample resources here in the forum and on the web for how to implement them. Searching will reveal all.