Macro to start AFTER choise from validation drop down list

**rpinxt** · 07-26-2012, 07:11 AM

Hi all,
Been looking at several of these solutions to get a macro to run AFTER one makes a choise in a drop down menu.
But (and thats why I write after in capitals) all these solutions only work for me when I click the cell in which the validation is.
That is not what one would want I think.

Lets say I have a validation in cell C3.
It are several names of person.
So I not even want to run a specific macro per person. It is even simpeler.
I want to run just 1 macro and then in the macro based on the name chosen I will identify what needs to be done.

However if I even can find a macro that would do what I want it starts right when I select C3.
But it must only activate when I CHANGE C3. Then it should call my macro (whatever name) and never under different circumstances.

Anybody able to help me with this code?
I would assume it to be a very simple few phrases code...
Thanks!

**smuzoen** · 07-26-2012, 07:22 AM

Say the drop down list is in H7 in sheet 1 then this code would go into Sheet 1 and would run the macro called myMacro AFTER the selection is made from drop down list- see attached workbook. I assume this is what you mean.

Please Login or Register  to view this content.

**bonny24tycoon** · 07-26-2012, 07:23 AM

Hi There,

Goto VBA Editor and Paste the below code on the sheet where you would have the C3 changed (note - do not add the below as a module as its a worksheet code)

Please Login or Register  to view this content.

**rpinxt** · 07-26-2012, 07:38 AM

see....I new it was simple!

I just was doing it slightly wrong...thanks guys and thanks smuzoen for the example.
Very helpful!

**Cutter** · 07-26-2012, 09:26 AM

@ rpinxt

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.