![]() |
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! |
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! |
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! |
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