run 1 macro automatically after any value chosen from drop down

**cdl** · 05-14-2008, 04:39 PM

I found the code below and tried to alter it for my use but was unsuccessful. Could someone please alter it or provide new code for me?
The code below runs 1 of 3 macros based on the item chosen from a drop down list. My needs are to run 1 macro ("SortCourse") no matter what item is chosen from the drop down list.
Many thanks in advance. Cindy

Please Login or Register  to view this content.

**VBA Noob** · 05-14-2008, 05:01 PM

Try

Please Login or Register  to view this content.

Change E1 to your cell

VBA Noob

**cdl** · 05-14-2008, 05:04 PM

Thank you very much. That works beautifully. Sorry I didn't get the Code wrap right the first time.
Cindy

**cdl** · 05-15-2008, 03:29 PM

Ok I'm stumped. This was working beautifully and now it's not. There were 3 sheets that were calling macros based on their pull down value. Now none of them work and the code is still there???? Nothing is happening when I choose something from the pull down. I was playing with new code to email sheets to various addresses (which I need to get help on later) - could that have done something? Any insight would be much appreciated. Thanks, Cindy

**VBA Noob** · 05-15-2008, 03:36 PM

The other code may be a issue.

Post a sample file (take out any info you don't want to see)

VBA Noob

**cdl** · 05-15-2008, 03:55 PM

VBA Noob,
Thanks for your help. The other code is there also that I need help with. I will post another thread if you tell me too. The other code was working also but now it isn't either. That sent me an email of the active sheet nicely. What I was trying to add was a range of people based on the drop down list results. I was trying to have it reference a range where the emails would be located and couldn't get that working.
I removed TONS of info to get the file size down and then I still had to zip it.

Thanks again,
Cindy

**VBA Noob** · 05-15-2008, 04:02 PM

The sheet code for Employee has the macro named Mail_ActiveSheet

This is not an event macro so should go in a normal module. BTW you have lots of empty modules. To get rid of an empty module

Right click > then select remove module

VBA Noob

**cdl** · 05-15-2008, 04:15 PM

Thank you VBA Noob. I removed the empty modules and moved the e-mail code from the sheet code to a module. Not sure what any of this means unfortunately but I'm learning. So, I'm the dropdown auto macro is working again and the email macro worked for sending me the email. Thank you for taking the time to help. Sincerely, Cindy