Can i select multiple names from a list

No, not really, you would need to use VBA ...

In the attached I created a multi select ListBox... and added some code such that when you select a cell within range C2:C20 (ie where you have previously used Validation) the ListBox defaults to reflect current selections (as inferred via names in cell) ... on alteration of selection the current cell updates accordingly.

You might want to think about making this more elaborate - ie via double click and userform window but that's not an area within which I have any level of competence ... so perhaps you will get some other examples in addition to the attached illustration.

If you go into Design Mode and Right Click on the ListBox -> Properties -> ListFillRange -> revise accordingly

Alternatively if you expect to change the listing frequently then you could think about creating a Dynamic Named Range (DNR) and using that as the ListFillRange.

For more info. on DNR see: http://www.contextures.com/xlNames01.html

NOTE:
if your ListBox list does not contain all the names present in the cell at point of selection you will get an error.

Change the Worksheet_SelectionChange event per below (alterations in red):

Please Login or Register  to view this content.