Selected checkbox values to one cell separeted by comma

[lemke27]

Hi, i have a form with more than 300 checkbox and different categories. I want to check a checkbox and see its value going to a specific cell. In other words: I want one cell that summaries all checked boxes separating it by commas.

So if my form is:

Option 1 Checked
Option 2 Not Checked
Option 3 Checked

Summary cell: Option 1, Option 2

Is there any code that i can do this?

Thanks!

[Arkadi]

Yep should not be hard... are the checkboxes named consistently? or is it simply every checkbox in the form?

Please Login or Register  to view this content.

then just put the string summary into the cell you need.