ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I insert a box that lets me check and uncheck it in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/67998-how-can-i-insert-box-lets-me-check-uncheck-excel.html)

The Lone Ranger

How can I insert a box that lets me check and uncheck it in Excel
 
I am looking to insert a selection box into an Excel spreadsheet that lets me
select it and unselect it as needed.

Dave Peterson

How can I insert a box that lets me check and uncheck it in Excel
 
Like a checkbox?

Show the Forms toolbar
View|Toolbars|check Forms
you'll see the checkbox icon on that toolbar.
click it and then click where you want the top left corner to be. Drag down and
to the right. (If you make it too large, you can resize it later.)

Rightclick on that checkbox and choose Format|Control
Then click on the Control Tab. Put an address (like A1) to use for the cell
link.

You can use that cell in formulas to determine if the checkbox is checked or
not.

=if(a1=true,"It's checked","nope")



The Lone Ranger wrote:

I am looking to insert a selection box into an Excel spreadsheet that lets me
select it and unselect it as needed.


--

Dave Peterson


All times are GMT +1. The time now is 03:10 AM.

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