Code for Multiple Selection Drop Down Works in Excel 03 but not 07

**Jocelyn** · 03-18-2009, 11:42 AM

Hi. I have a spreadsheet with several drop down lists. The code posted below, for allowing multiple selections in one cell, works in Excel 2003 however it does not seem to work with Excel 2007. Any idea as to why?

Please Login or Register  to view this content.

**Andy Pope** · 03-18-2009, 12:17 PM

That code works for me in xl2007.

Can you post workbook where it doesn't work.

**Jocelyn** · 03-18-2009, 12:53 PM

Here's the workbook. I chopped it up quite a bit for purpose of uploading here.

Please see if the last two columns allow you to make multiple selections in one column. Our 2007 users are having issues but everyone else is fine.
Thanks!

**Andy Pope** · 03-18-2009, 01:02 PM

Yes that works okay.

Do you have SP1 installed?

**Jocelyn** · 03-18-2009, 01:54 PM

I do have SP1. You too?

**Andy Pope** · 03-19-2009, 05:27 AM

yes I have SP1

You will need to debug the code.
go to the vbe and put a breakpoint (F9) on the first line of code in the event.
then next time you use the dv on the sheet you should be put in debug mode within the event. From here you can step through the code and see what information is stored and what lines of code are executed. Hopefully then the problem will be revealed to you.