+ Reply to Thread
Results 1 to 4 of 4

Comparing Check Boxes

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Hartford, CT
    MS-Off Ver
    Excel 2007
    Posts
    2

    Comparing Check Boxes

    Is there a way to set up a formula so that it can check two cells with check boxes in them and return a value, similar to the exact formula, i.e. true, false, etc? Even better would be if it checked the text in the cell and the check box and see if they match.

    I am pasting fields with check boxes next to them from an online database into Excel. It would make my task a lot easier if there was a function that could identify if any of the check boxes are different. My goal is to have a reference sheet, and then each time I have to do an audit, I could paste the current fields in a different sheet, and a formula would be able to tell me if any of the fields have changed.

    Thanks in advance for any suggestions or answers.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Comparing Check Boxes

    Are you using the developer tab to insert your checkboxes? If you do it that way, you can right click on each checkbox and select format control. Then use the cell link option: it will display "TRUE" or "FALSE" based on whether the box is checked or not.
    <--- If you like the answer, press *.

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    Hartford, CT
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Comparing Check Boxes

    Actually I am copy and pasting them from my web browser, which ends up being a check box and the field label in the same cell.

  4. #4
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Comparing Check Boxes

    Hmmm... that one's more difficult to help with. Can you upload a sample so I can see what type of checkbox you're actually pasting in?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-23-2013, 10:42 AM
  2. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:56 PM
  3. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  4. Automatic setting of check boxes based on other check boxes?
    By ArchiveMike in forum Excel General
    Replies: 5
    Last Post: 07-31-2012, 09:43 AM
  5. Comparing items in two different columns with check boxes
    By ptborders in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2012, 12:04 PM

Tags for this Thread

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