Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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!

Re: Check-box value in formula

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

Dave

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.

Regards

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.