+ Reply to Thread
Results 1 to 3 of 3

How do I create a single cell including multiple information of a list of checkboxes

  1. #1
    Registered User
    Join Date
    01-12-2021
    Location
    germany
    MS-Off Ver
    365
    Posts
    2

    How do I create a single cell including multiple information of a list of checkboxes

    Hello dear forum members!
    Sorry that my question might appear silly/easy but I am not good at using excel yet:

    My plan is to create a questionnaire including a list of roughly 50 questions. When I have a new customer I want to select some of those 50 questions - let`s say 10. Preferably this would be done by a check box. If there are other easier options please let me know. The questions behind the checkbox should be grouped under each other in one single cell so I can copy and paste them into an E-Mail and ask the customer.

    To show what I mean I created an example. I have done everything manually in it and want it to be automated:

    questionnaire example.png


    Any help is highly appreciated.
    Thanks in advance and have a nice weekend everyone!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: How do I create a single cell including multiple information of a list of checkboxes

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: How do I create a single cell including multiple information of a list of checkboxes

    Hi. In the end, I made a sample myself. I wouldn't bother with the check bxes, myself. You have to link each one to a cell that returns TRUE or FALSE, and then use a formula:

    =IFERROR(TEXTJOIN(CHAR(10),TRUE,FILTER(F3:F11,D3:D11=TRUE)),"")

    I'd just make a list and put an X or whatever, in an adjacent cell

    =IFERROR(TEXTJOIN(CHAR(10),TRUE,FILTER(K3:K11,J3:J11<>"")),"")

    see sheet. In D, you may need ; instead of ,
    Attached Files Attached Files

+ 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. Multiple checkboxes to populate single cell
    By Watchdawg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-13-2019, 12:50 PM
  2. Multiple Checkboxes inside Single Excel cell
    By kripshome in forum Excel General
    Replies: 1
    Last Post: 05-14-2018, 10:53 AM
  3. VBA Troubleshooting - Multiple Issues including randomly appearing checkboxes
    By Storm08 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2018, 11:02 AM
  4. Replies: 5
    Last Post: 09-30-2012, 07:47 AM
  5. Replies: 0
    Last Post: 09-20-2012, 05:23 AM
  6. [SOLVED] Multiple Checkboxes to Create a List
    By robstark in forum Excel General
    Replies: 4
    Last Post: 07-25-2012, 03:33 PM
  7. Replies: 2
    Last Post: 09-06-2010, 01:26 PM

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