Solved

Excel checklist within a cell (similar to the checklist per cell used in MS Project)

Posted on 2014-10-20
4
192 Views
Last Modified: 2014-10-22
I have a large spreadsheet with one column setup with Data Validation lookup to a list of 94 items. This list is color coded and I am struggling for a good way to have this list of 94 (per cell in column BT); part of the challenge is keeping the row height to 20px for ease of viewing.
So...I was thinking about keeping the cells small in column N, but have a drop-down display where any of the 94 validation items may be check marked.

Dear experts, I am not sure this is the best solution and am hoping you might have suggestions on how to do this. I am including the (scrubbed) file in question: please see column "BT" and the lookup to the 94 items on the CALC tab.

Thank you!
JohnD
Retail-Lab-status-example.xlsm
0
Comment
Question by:johndarby
  • 2
4 Comments
 
LVL 15

Expert Comment

by:David L. Hansen
ID: 40393353
You can use a "named range" to define the 94 choices and then assign this named range to be the source for a dropdown box placed in the BD cells.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40393386
Select BT3 and go to Data Validation. In Allow: select List, In Source:, enter "=Calc!N2:N95" (without quotes). Copy BT3 and past down to BT45. This will give you a drop-down for each cell. See attached.
Flyster
Retail-Lab-status-example.xlsm
0
 
LVL 1

Author Comment

by:johndarby
ID: 40393657
Hey guys, thank you;  I already have the data validation working...my ask is if the drop down list could be configured with check boxes to multi-select items; I expect this is some VBA development
0
 
LVL 15

Accepted Solution

by:
David L. Hansen earned 500 total points
ID: 40397080
How about using a ListBox with its multiselect property set to True.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now