Solved

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

Posted on 2014-10-20
4
212 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

756 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