+ Reply to Thread
Results 1 to 3 of 3

How ti link together checkboxes from different popages?

  1. #1
    Registered User
    Join Date
    01-09-2021
    Location
    Vietnam
    MS-Off Ver
    dont know
    Posts
    2

    How ti link together checkboxes from different popages?

    Good day.
    Please help me to have checkbox on second pages checked automatically, when check box on page 1 is checked.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How ti link together checkboxes from different popages?

    On the first sheet right click on one of the check boxes and select "Format Control". In the "Cell Link:" box enter a cell reference of an area of the sheet you're not using and can be hidden away. Q1 for example.
    Then go to the second sheet and do the same but rather than just putting Q1 in the cell link box you need to put sheet name and cell reference. So it will look like 'Requisition from Unit'!Q1 (Note because your sheet name has spaces you will need to wrap the sheet name in single quotes).

    Repeat the above for all the checkboxes, using a difference cell for each, and now they will be linked and will match each other regardless of which sheet you change the tick box status on.

    BSB

  3. #3
    Registered User
    Join Date
    01-09-2021
    Location
    Vietnam
    MS-Off Ver
    dont know
    Posts
    2

    Re: How ti link together checkboxes from different popages?

    Thank You so much for your 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. [SOLVED] Is there any way to link multiple checkboxes on the same sheet with a macro?
    By Miguelhn94 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2019, 12:04 AM
  2. [SOLVED] How to link multiple active x checkboxes to cells
    By Dena in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2017, 05:42 PM
  3. Checkboxes in userform link to cells
    By Konexcelmath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2015, 05:58 PM
  4. [SOLVED] mutually link checkboxes
    By j_angelo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2015, 02:52 PM
  5. [SOLVED] link active x checkboxes
    By MATT.B in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2015, 04:53 PM
  6. Replies: 11
    Last Post: 02-14-2013, 06:39 PM
  7. [SOLVED] Link Checkboxes and Grey out the Check
    By Patrick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 11:05 AM

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