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

**Granatapf3l** · 02-05-2021, 07:46 AM

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!

**Glenn Kennedy** · 02-05-2021, 07:48 AM

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 Kennedy** · 02-05-2021, 08:04 AM

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 ,

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Multiple checkboxes to populate single cell

Multiple Checkboxes inside Single Excel cell

VBA Troubleshooting - Multiple Issues including randomly appearing checkboxes

Trying to create a multiple user to do list that generate information to separate sheets

Need help to Pull information out of a Single Cell and into Multiple columns

[SOLVED] Multiple Checkboxes to Create a List

Is there a way to create multiple checkboxes/radio boxes in one cell?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions