Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am looking to insert a selection box into an Excel spreadsheet that lets me
select it and unselect it as needed. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a way to add up check boxes | Excel Discussion (Misc queries) | |||
how do you add up check boxes | Excel Discussion (Misc queries) | |||
How to protect shapes in Excel | Excel Discussion (Misc queries) | |||
How do I print grayscale font in Excel 2003? | Excel Discussion (Misc queries) | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |