+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    The Lone Ranger
    Guest

    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. #2
    Dave Peterson
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1