http://blogs.office.com/b/microsoft-excel/archive/2012/08/21/select-multiple-names-from-a-drop-down-list.aspxOur guest blogger and Excel MVP award winner, Debra Dagleish, makes it easy to create an Excel dropdown list that lets you select multiple names in one cell. The magic to her method is adding a few lines of VBA code--a trick just about anyone can learnen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/08/21/select-multiple-names-from-a-drop-down-list.aspx#33983Tue, 02 Oct 2012 13:12:20 GMT53587256-c606-4c9b-bad4-97c86b12ce62:33983trobinson11@gmail.com<p>I want to have dropdown boxes that allows you to select multiple items in two different columns (column B and column D). &nbsp;How would I code this? &nbsp;Thanks.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=33983" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/08/21/select-multiple-names-from-a-drop-down-list.aspx#33395Tue, 28 Aug 2012 05:30:59 GMT53587256-c606-4c9b-bad4-97c86b12ce62:33395Walter Zheng<p>error occurs when i try to delete name in cell</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=33395" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/08/21/select-multiple-names-from-a-drop-down-list.aspx#33333Thu, 23 Aug 2012 19:06:23 GMT53587256-c606-4c9b-bad4-97c86b12ce62:33333Ameer<p>Super post...</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=33333" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/08/21/select-multiple-names-from-a-drop-down-list.aspx#33298Wed, 22 Aug 2012 14:20:29 GMT53587256-c606-4c9b-bad4-97c86b12ce62:33298FearNaught<p>This is good however it allows you to add duplicates of the same name.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=33298" width="1" height="1">