Return a string from multiple checkbox results

**dillinger** · 04-26-2010, 09:21 AM

Hello! I'm new here and looking for some assistance. I've got 8 checkboxes and I'd like to be able to check any number of them and return a string based on only the TRUE results. So, if the results are A, B, C, D, E, F, G, H I'd like to be able to return the string: "A, C, and F" or even just "B" or "C, D, E, and H". Does that make sense? I've got the checkboxes returning the correct words I need if any of them are checked, it's the getting of the string I'm having issues with. Anybody able to help?

Thanks!

**davesexcel** · 04-26-2010, 07:32 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Palmetto** · 04-26-2010, 08:13 PM

You can do this without code if it fits your situation.

Assuming check boxes are linked to cells, say A1:H1, then in the row below each cell you could use this formula:

=IF(A$1=TRUE,"A ","")

And in the cell to show the string, this formula:

=A2&B2&C2&D2&E2&F2&G2&H2

See if the attached is of any help. Otherwise,as davesexcel points out, upload a sample workbook.

**dillinger** · 05-01-2010, 11:46 AM

Originally Posted by Palmetto

You can do this without code if it fits your situation.

Assuming check boxes are linked to cells, say A1:H1, then in the row below each cell you could use this formula:

=IF(A$1=TRUE,"A ","")

And in the cell to show the string, this formula:

=A2&B2&C2&D2&E2&F2&G2&H2

See if the attached is of any help. Otherwise,as davesexcel points out, upload a sample workbook.

That totally worked. I can't believe I didn't think of that. Thank you so much for the help!

PS: Sorry it took me until today to get back to you. I work the weekend shift.