Results 1 to 3 of 3

Thread: Linking a check box to a column in a table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2017
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Linking a check box to a column in a table

    I have a check box on a worksheet that I would link to a field in a column. The issue that it is a table and I would like to be able to have the linked field always be the new line in the table. is this possible?

    Thank you.

  2. #2
    New Member
    Join Date
    May 2007
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Linking a check box to a column in a table

    I'm assuming the field in the table contains a boolean either 1 or 0 or "True" or "False" and that you would like the check box to reflect the boolean value in the last row a specific column in a table. If that is the case, I would place the formula below in any cell you prefer, and then reference that cell in the "Cell link" field of the checkbox control. Of course replace "Table" with your table name and "Column" with the name of your column


    =INDEX(Table[Column],COUNTA(Table[Column]),1)
    Last edited by smaur; Oct 18th, 2019 at 03:36 PM.

  3. #3
    New Member
    Join Date
    Sep 2017
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Linking a check box to a column in a table

    Thank you so much

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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