+ Reply to Thread
Results 1 to 5 of 5

Insert a checkmark by selecting a cell, remove checkmark by deselecting the cell.

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    Durand, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    49

    Insert a checkmark by selecting a cell, remove checkmark by deselecting the cell.

    I have a questionare that I would like customers to fill out and I would like for them to simply click in the yes or no box and it will display a checkmark. I tried several attempts to work with a macro and it still would not do it. Please help. I have attached the sheet that I am working on.Kim's Marketing Letter 1-11.xls

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Insert a checkmark by selecting a cell, remove checkmark by deselecting the cell.

    Instead of drawing border around a cell, why not insert a checkbox from the forms menu. It acts in the manner you wish to employ.

    http://office.microsoft.com/en-us/ex...010236677.aspx

    Alan
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-24-2012
    Location
    Durand, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Insert a checkmark by selecting a cell, remove checkmark by deselecting the cell.

    I am using excel 2003, this information is for Excel 2007.

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Insert a checkmark by selecting a cell, remove checkmark by deselecting the cell.

    1 Right-Click on a blank area of the menu area
    2 On the list which appears click on Forms
    3 Click on the CheckBox in this Forms toolbar.
    4 Off the toolbar the mouse turns into a hair-cross
    5 Click where you want the CheckBox to appear
    6 Drag the shaded outline to position it accurately
    7 Right-click within the shaded area but not in the checkbox
    8 In the context menu which appears select Edit Text to change or
    remove the text, dragging the shaded outline to size it.
    9 In the right-click context menu (as in 7- select Format Control
    10 Select the Control tab
    11 Set the initial setting of the control box
    12 Click in the Cell Link entry box, then click in the cell where you
    want to place or receive the checkbox status
    13 Click OK on Format Control

  5. #5
    Registered User
    Join Date
    07-24-2012
    Location
    Durand, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Insert a checkmark by selecting a cell, remove checkmark by deselecting the cell.

    WOW got it Thank!!!

+ 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