+ Reply to Thread
Results 1 to 3 of 3

Can't get check boxes to do what I need

  1. #1
    Registered User
    Join Date
    04-13-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 2011 for mac
    Posts
    7

    Question Can't get check boxes to do what I need

    I would like to create a checkbox to do some work for me in an excel spreadsheet. I am a novice and have spent many hours trying to figure this all out.
    So here is what I am trying to do:
    Place a checkbox in A1
    If the check box in A1 is checked it copies the value of B1 and inserts it into C2
    If the checkbox in A1 is unchecked it removes the value of B1 that was inserted in C2 above and leaves C2 blank
    Place a checkbox in A3
    If the checkbox in A3 is checked it copies the value of B3 and inserts it into C2
    If the checkbox in A3 is unchecked it removes the value of B3 that was inserted in C2 and leaves C2 blank
    If A1 is checked, A3 can't be checked at the same time
    If A3 is checked, A1 can't be checked at the same time
    Both A1 and A3 can be unchecked however and C2 is left blank.
    I have tried recording macros but they don't seem to work properly. Thanks for your help.

  2. #2
    Registered User
    Join Date
    02-23-2014
    Location
    Michigan, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Can't get check boxes to do what I need

    Insert a checkbox, select it and select View Code.
    Try this code:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-13-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 2011 for mac
    Posts
    7

    Re: Can't get check boxes to do what I need

    I am using excel in mac. I tried doing "assign a macro" to the check box but the code above didn't work. It hangs on the the second line? Not sure why I am making this so difficult. I was able to do this easily using Numbers for mac but need to do the same sheet in excel to be able to distribute it. When I do a simple conversion the check boxes change and then don't behave the same in Excel as numbers. I know Excel is more powerful but that seems to make it more difficult.
    Thanks for the help.

+ 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. Excel VBA to generate check boxes and restrict user to tick on the 3 boxes in a row
    By rhodalynn.rona in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 05:55 AM
  5. 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

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