• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

excel checkbox pick list

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
John Darby
Asked:
John Darby
  • 3
2 Solutions
 
Michael FowlerSolutions ConsultantCommented:
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
 
John DarbyPMAuthor Commented:
Thank you...I will look at this when I get home
0
 
Phillip BurtonCommented:
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
 
John DarbyPMAuthor Commented:
The first solution was just what I hoped for...the second solution was much appreciated!
0
 
John DarbyPMAuthor Commented:
Thank you!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now