Solved

excel checkbox pick list

Posted on 2014-12-20
5
211 Views
Last Modified: 2014-12-22
Greetings!
I have a list of 30 items in a table which I have as part of a pick-list in a group of cells in a column. I would like to do 2 things:

1. make the pick list items where I can select more than one item
2. make the method of selection a drop-down list where each item in the list is selectable by checking a box (similar to MS Project)

Thank you!
JohnD
0
Comment
Question by:johndarby
  • 3
5 Comments
 
LVL 23

Accepted Solution

by:
Michael74 earned 350 total points
ID: 40512016
This can be done but requires some VBA to work. I have attached an example from another site (I cannot mention this site due to the rules) where this has been done.

ListBoxSetup.xlsm
0
 
LVL 1

Author Comment

by:johndarby
ID: 40512239
Thank you...I will look at this when I get home
0
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 150 total points
ID: 40512813
Why not use a Microsoft Forms ListBox or ComboBox? You can have a multiple-selection list using those.

If you want to read more about it, have a look at this site: http://office.microsoft.com/en-gb/excel-help/add-a-list-box-or-combo-box-to-a-worksheet-HP010236681.aspx
0
 
LVL 1

Author Comment

by:johndarby
ID: 40513541
The first solution was just what I hoped for...the second solution was much appreciated!
0
 
LVL 1

Author Closing Comment

by:johndarby
ID: 40513752
Thank you!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

747 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

9 Experts available now in Live!

Get 1:1 Help Now