Macro choice triggered by a drop-down list

[wolfm]

I am trying to write a macro that will:
Run the macro "Sub Emailstraightruckreq()" (or Module48) if the second value in my drop-down list in cell A28 of my current worksheet is selected.
I also want this macro to run the macro "Sub Emailshowreq()" (or Module8) if the first value in my drop-down list in cell A28 of my current worksheet is selected.

I don't know where to start, or even if you can run two macros within a macro.

I hope this makes sense??

Thank you.

[stnkynts]

One option, put in the worksheet change event. You will have to modify to meet your specific information.

Please Login or Register  to view this content.

If you don't want this as a worksheet change and want it only done when you want to run it as a macro then

Please Login or Register  to view this content.

[tigeravatar]

Something like this should work. Change "First value" to be the actual first value and change "Second value" to be the actual second value. This code goes in the worksheet module of the worksheet that contains the drop-down list in cell A28

Please Login or Register  to view this content.

[EDIT]: Beat to it by stnkynts

[wolfm]

I used the second option. It worked great! You are awesome!!