Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Lone Ranger
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to add up check boxes strider11580 Excel Discussion (Misc queries) 2 January 24th 06 04:37 AM
how do you add up check boxes strider11580 Excel Discussion (Misc queries) 1 January 22nd 06 03:35 AM
How to protect shapes in Excel mslava123 Excel Discussion (Misc queries) 1 May 24th 05 09:11 PM
How do I print grayscale font in Excel 2003? NKT Excel Discussion (Misc queries) 0 January 26th 05 04:51 PM
How do I view the actual numeric value of a formula in Excel 2002. Excel Function Help Excel Worksheet Functions 0 January 13th 05 10:07 PM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"