MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Check-box value in formula

Posted by Dave C on August 24, 2001 4:45 AM

I have 13 columns (labled with workers' initials)with 62 rows. The rows contain check-boxes. I would like to output the value of all the checked columns to a second worksheet, using the columns label. That is, if the check-box is checked under the column heading of MH and DC, but not CL then on the second worksheet I would like it to display something similar to "MH, DC". Note that "CL" would not be listed because it was unchecked. It would also be feasible to have all 13 checked, listing all of the 13 initials (labels). Is this possible? If you are totally confused, email me and I can send you a sample worksheet. Thanks in advance!

Posted by Robb on August 24, 2001 5:52 AM


From what you indicate, I would say what you want to do is entirely possible. How to do it, however, depend on a couple of things:

-What sort of checkboxes are you using (ActiveX or Forms)
-Do you want the initials to all appear in one cell or separate
-Do you want to copy any other of the data from the columns

I've posted my e-mail if you would like to send a copy of the worksheet.