Results 1 to 3 of 3

Thread: Casting checkbox values into another spreadsheet

  1. #1

    Casting checkbox values into another spreadsheet

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone!


    As I'm diving into this new VBA world new issues and ideas are coming out of my mind. One of these are about casting checkbox values into another spreadsheet:

    The Problem:
    - I have a spreadsheet with several checkbox one-correlated with a checkbox in another spreadsheet (same workbook).

    What I need:
    - When the user check a box on 'sheet1' its correlated checkbox turn its value to checked too.
    - If one checkbox changes its values, its correlated changes too, and vice-versa. It will work like a mirror, one always affecting the correlated, and vice-versa.

    This attach may help to understand

    I don't know if VBA is the only way to solve it; hope not, hope there is a solution with formulas to check (or uncheck) both checkboxes.

    My best regards!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Why not just link the two checkboxes to the same cell.

  3. #3
    Thank you Bob Phillips!


    It really worked!

    Here's the implementation:

    Anyway, I'm wondering if there's a way to 'link these cells' in PowerPoint ?

    I'd like the user to click the boxes during the full screen slide view, and then, link the values of the boxes in a excel worksheet.

Tags for this Thread

Posting Permissions

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