+ Reply to Thread
Results 1 to 2 of 2

Button to know what checkbox are marked

  1. #1
    Registered User
    Join Date
    10-25-2006
    Posts
    48

    Button to know what checkbox are marked

    i have 3 checkboxes, each one with different text.

    i would like to create a button to know each of 3 checkbox are marked, and copy the checkbox label to another cell.
    is this possible ?

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Button to know what checkbox are marked

    In 'format control' --'control'--cell link se 3 different cells (say A1,B1,C1) for each of the checkboxes.

    Then in Cell D1 (say) use =AND(A1,A2,A3,TRUE) whcih will reflect TRUE only whne all 3 are checked. Is this what you are after?
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    10-25-2006
    Posts
    48

    Re: Button to know what checkbox are marked

    Attachment 176601

    basically this screenshot shows what i'm trying to do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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