Thanks I think this will work but I have an additional question, I've never
used viisual basic code with excel, how do I apply this code to a certain
cell or pull down list?

Thanks again

"Gord Dibben" wrote:

Download a sample DV workbook from Debra Dalgleish's site.

http://www.contextures.on.ca/excelfiles.html#DV0017

Note that you can have the selections in an adjacent cell or in the same
cell.



Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 11:56:54 -0700, aspenelk
wrote:

That did not cover how to select more than one item at a time from a pull
down list.

i.e. a pull down list has items: 1, 2, 3, 4

in it

I want to be able to select possibly items 1 & 3 at the same time as a choice

thanks

"Jacob Skaria" wrote:

For 2007; try
http://www.youtube.com/watch?v=7DkoRjd_8L4

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Watch this 1 min video
http://www.youtube.com/watch?v=i-w5i...eature=related

If this post helps click Yes
---------------
Jacob Skaria


"aspenelk" wrote:

Trying to figure out how to create a pull down list where multiple items can
be choosen from the list

thanks,