Multiple Selection DropDown Macro

  • Hi guys,
    So, I have a dropdown menu on a cell which contains a list of countries, like this :

    Please Select
    Not Applicable
    Country 1
    Country 2
    Country n

    Multiple "country" answers are possible, so I use the below macro to allow multiple selections from the dropdown menu.
    But, as Please Select is my "default" answer, it also appears in the final answer and I would want the macro to "ignore" the Please instead of: "Please Select, Austria, Belgium, Bulgaria etc" to be "Austria, Belgium, Bulgaria etc".

    Any ideas in how to do it?

  • Re: Multiple Selection DropDown Macro

    Try this:

Participate now!

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