[SOLVED] Two multiple choice drop down lists on one sheet

[Dicemum]

Hi,

I'm new to VB and I am trying to have more than one drop down list on my sheet that allows the user to make multiple selections from a list. Each drop down is a different list. I found code that works for one drop down per worksheet, but can't figure out how to add to the code for the second drop down. Do I need to do a bunch of nested IF statements?? It's been years and years since I've done any programming so I apologize in advance for my newbie-ness.

I've attached the spreadsheet with the code from trumpexcel. I tried editing etc (for the past 3 hours ) but won't give you my bastardized attempts. The one that is attached is unedited and works. The code works on the "number" dropdown and I also want to allow multiple selections in the "alpha" dropdown.

Any help would be appreciated! Or am I trying to do something that can't be done?

Thank you!

[Dicemum]

Hi all - can anyone help? Thanks!

[Arkadi]

After your final End If, just put in similar code but If Target.Address = "$D$2". That would then only run if it was your "other" dropdown that changed. Unless the code is supposed to do EXACTLY the same thing, then you could just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Dicemum]

So simple! Thank you SO much.

[Arkadi]

Glad I could help, if that solves the problem, please remember to mark the thread as solved? Thanks in advance