call macro with validated dropdown menu

[needhelp2]

Hello everybody,

I am using excel 2007.I have create some macro that if some value select from validated drop down then it calls for my saved macro to run

Is there any easy way to run it?
my macro is saved with name of macro2.

Best Regards,
Rob.

 

[pedie]

try something like this in worksheet module:

[/FONT]
[FONT=Courier New]Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
    msgbox "run macro2??"[/FONT]
[FONT=Courier New]    call macro2[/FONT]
[FONT=Courier New]End if[/FONT]
[FONT=Courier New]

 

[needhelp2]

wao thats great Pedie i want to knwo that if i have some other macros e.g macro3,macro47 so i can use the same script?

 

[pedie]

That was just an example...you can it the way you want to...
Let us say you have 3 macros...and 3 validation list...[apple, mango and banana...]

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
'sometime you may want to turn off events and then
'run..and turn it back on again
if target.value = "Apple" then call macro1
if target.value = "Mango" then call macro2
if target.value = "Banana" then call macro3
'etc....
End if
end sub

 

[needhelp2]

Its really helpfull for me.But now my macros are not being working when ever i select like mango from drop down.....it attached with Macro2.

 

[pedie]

Try this way..i have not tested this code as my office is not installed in my notebook

[/FONT]
[FONT=Courier New]If Not Intersect(Target, Range("A1")) Is Nothing Then
'sometime you may want to turn off events and then 
'run..and turn it back on again[/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]Application.EnableEvents = False[/FONT]
[FONT=Courier New]
if target.value = "Apple" then 
call macro1
end if
if target.value = "Mango" then 
call macro2
end if
if target.value = "Banana" then
 call macro3
end if
'etc....
Application.EnableEvents = True

End if
end sub

 

[needhelp2]

Thanks i modify a bit in script provided by your its perfect now......... Thanks you very very very much.I haven't any more words to say thanks but you can give me a chance to say any more

 

[jasonofshanghai]

Hi Needhelp2,

I have the same probelm and need hemp solution as you, but I am not VBA expert like u guys. I wonder if u could kindly share with me your solution ? I have dropdown list of 11 entries, and 11 macros that i hope to run with each selected entry from the dropdown ..

Many tkx,
Jason