ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I incorporate a "check-box" in Microsoft Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/58408-how-do-i-incorporate-check-box-microsoft-excel.html)

app2121

How do I incorporate a "check-box" in Microsoft Excel?
 
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

How do I incorporate a "check-box" in Microsoft Excel?
 
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
viewtoolbars


--

Regards,

Peo Sjoblom


"app2121" wrote in message
...
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!




app2121

How do I incorporate a "check-box" in Microsoft Excel?
 
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" wrote:

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
viewtoolbars


--

Regards,

Peo Sjoblom


"app2121" wrote in message
...
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

How do I incorporate a "check-box" in Microsoft Excel?
 
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)


"app2121" wrote in message
...
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" wrote:

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
viewtoolbars


--

Regards,

Peo Sjoblom


"app2121" wrote in message
...
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!







All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com