How do I incorporate a "check-box" in Microsoft Excel?

[Guest]

I am building a spreadsheet that will have multiple options for the intended
user. I know that through Microsoft Excel you can build a "check-box" where
the user would just simply click on a box and it automatically is checked. I
just want to know how to do this.

Thanks!

 

[Peo Sjoblom]

If you want options it's better to use the option button, regardless they
are in either the forms toolbar or the control toolbox toolbar under
view>toolbars

 

[Guest]

Thanks! I was able to pull this up. However, when i import it into the
spreadsheet, I haven't figured out how to get it so when one clicks on the
box that a check appears. Any help along those lines?

Thanks!

 

[Peo Sjoblom]

Which one did you use, if from the forms toolbar just click it, then hold
down alt and click in a cell
then use it by clicking with the mouse if you use the one from the control
toolbox you can apply it the same way but to use it you need to click a
button to exit design mode, it's the one that has a triangle in it

--
Regards,

Peo Sjoblom

(No private emails please)