Solved

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

Posted on 2014-10-20
4
216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

738 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