Multiple Selection for a Dropdown List

[awolf2011]

Hey all,

I am a pretty good user at Excel but know very little about the VBA and writing MACROS. In fact I am just starting to learn these.

Anyways, I am needing to create a drop down list in my excel sheet that will allow me to select one or more possible selections that will populate into that cell.

I imagine this is down with VBA and MACRO writing. If true, does anyone have the code that can easily be used? If so, could you be so kind to also let me know how to copy the code into my workbook and tailor it to my specific drop down criteria.

I have seen some issues on a site I think is called conetextures.com but am unsure of how to get the VBA code into my work book and it tailored to my criteria.

[JBeaucaire]

With no sample workbook, then here's a way to watch a single cell and create a mult-selection window. In this case the cell is $E$15.

These macros are automatic. Right-click on the sheet-tab, select VIEW CODE and paste these codes into the sheet module that appears:

Please Login or Register  to view this content.

Close the VBA window and save your workbook as macro-enabled. It should be automatic after that.

[awolf2011]

Here is the thing we are building. It's for us to track the cases of veterans we receive. Some veterans may have more than one issue (see lists tab). The list of issues is generalized now because I am not sure how to incorporate this into the drop down list where we can then select more than one issue (if applicable).

[awolf2011]

Whoops, here is the file ....

[kvsrinivasamurthy]

Pl select the cells and use
Data-validation-Settings-
In allow select 'List'
For Source select the list from other range.

[JBeaucaire]

Which columns did you want to allow multiple selections? D? E? Both?

[JBeaucaire]

If it's both columns D & E that allow multiple choices, put these macros into the sheet module:

Please Login or Register  to view this content.