Solved

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

Posted on 2014-10-20
4
228 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

695 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