Have you downloaded the sample workbook Debra provides?

In that workbook she shows several different ways to combine the selections.

You do not "run" the code. As Dave points out, it is event code and runs
when you make a change in a dropdown.


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 16:13:02 -0700, TripMom
wrote:

I've created a drop down list with Data Valuation and would like to allow
multiple selections. I used the macro on contextures.com to create the
macro, however, when I return to the sheet right click, assign macro isn't an
option and running it doesn't work either. I'm on Excel 2007 and the much
loved Vista Home 64. Thanks in advance for your help.