Running a Macro based on a Value through a Command Button

[Joshyd]

Hi,

Here is the problem in a nutshell. I Made several macros that create emails. Basically, I have a drop down list that has the title of each of these emails. I would like there to be a command button adjacent to this drop down list that, when clicked, will run the macro for the corresponding entry on the drop down list.

Example:

If "email 1" is selected from the list, when the button is pressed, the macro "make_email_1" is run.

All help is much appreciated.

Thanks,
Josh

 

[Eric W]

There are several ways to do this, probably the easiest is to write another macro that does the selecting:

Sub Email_Selector()


    Select Case Range("A1").Value
        Case "email 1": Call make_email_1
        Case "email 2": Call make_email_2
        Case Else: MsgBox "Unknown email type"
    End Select
End Sub

Change the A1 to where your drop down list is. Then put your button on the sheet and set its macro to Email_Selector.

 

[Joshyd]

Thank you so much Eric! That is exactly what I was doing, as it turns out, I had a space at the end of me "email 1" and I never thought to put in an option with an error box so I did not get why it was failing. Thank you for reminding me of an important practice!

 

[Eric W]

Glad to help!