using Activex comboxbox to trigger respective action

  • Hello Respected members,


    I am trying comboboxes for first time and i am not able to figure out how to tell button to perform action based on values selected in combobox.

    I understand how to trigger a macro from button but i do not get how to trigger specific action when the button has/should follow critieria from drop down values of combobox.

    I am attaching the workbook where my ask is to send email to students with specific subject and priority - please look at sheet named as requirement in attached workbook


    Thanks in advance

  • Try this.


    My code will generate a string of Email recipients who meet the combo box criteria. That string can then be parsed to your emailing code to be used in the "To" bit of the code (.To sTo)

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!