Loop through drop down list and then call other macros

[DPhilip]

Good Morning. Anyone point out to me how to loop through a drop down list and then call another macro?

Ex. Drop down list:
Apple
Orange
Peach
Mango
Plum

I want it to go to apple first, run a macro I already use have then move to Orange and run the macro again until i get to plum and stop.

Right now I go to Apple then run the macro, then manually go to Orange, run the macro.. I have about 200 on my drop down list and this will save a lot of time.

Thanks in advance.

 

[DPhilip]

Yes I did

Have you replaced this line of code, from Mike's code in post #4,

Call otherMacro

with this?

Call RunAllMacros

 

[Norie]

Can you post the exact code as you have it now?

Also, where is RunAllMacros located?

 

[DPhilip]

SUB Loopthroughdropdown()
Dim oneThing as Variant
Dim ListOfThings as Variant

With Sheets("Control Slicer").Range("E3").Validation
If .Formula1 Like "=*" Then
ListOfThings = Evaluate(.Formula1)
Else
ListOfThings = Split(.Formula1, ",")
End If

For Each oneThing in ListOfThings
.Value = oneThing
Call Runallmacros
Next oneThing
End With
End Sub

Can you post the exact code as you have it now?

Also, where is RunAllMacros located?