Multiple data validation

[Human2014]

Hello all,

I am trying to create a drop down menu in order to be able to select multiple countries in one cell.

For example, I want cell C3 to have a drop down menu with one country then a selection of many countries.

e.g. Brazil, Australia, France

Attached the file.

Is it possible ?

[JBeaucaire]

That would require the use of VBA programming. Is that ok to use in your projects?

[Human2014]

That would require the use of VBA programming. Is that ok to use in your projects?

yes please go ahead, thank you

[JBeaucaire]

Then the technique published here will do the trick.
https://sites.google.com/a/madrocket...ulti-choice-dv

You want to use version #2.

1) Right-click the sheet tab and select VIEW CODE to open the sheet module in the VBA editor

2) Paste in the vba code found on that sheetm version #2

Be sure to edit the code to watch the range of cells you want. The code as written is watching cells A1:A10, you might change that to C2:C100 or something like that.

3) Close the VBA editor and save your workbook as a macro-enabled workbook (CountryList.xlsm)

Now as you make selections in your column C you can make multiple selections.

To start over in a cell, press DELETE to clear the cell completely.

[Human2014]

I just did but I only have one country selection.

See Attachment.

[Human2014]

Thank you JBeaucaire.