Hello everyone,
I'm trying to find VBA code where I can select multiple cities from a ListBox and output 5 email addresses associated with that city. The ListBox would only list the cities. The user would also be able to select more than one city. In my data, the city is in column "A" and the 5 email addresses are in columns B through F. The output would be on the same sheet in cell G1. So in the end, with 3 cities selected, the contents of G1 would have 15 email address (3 cities x 5 email addresses per city) separated by a semi colon so the user could just copy the results in G1 into the To field in an email. Anyone know where I can find this or offer some sample code? Thanks in advance.
I'm trying to find VBA code where I can select multiple cities from a ListBox and output 5 email addresses associated with that city. The ListBox would only list the cities. The user would also be able to select more than one city. In my data, the city is in column "A" and the 5 email addresses are in columns B through F. The output would be on the same sheet in cell G1. So in the end, with 3 cities selected, the contents of G1 would have 15 email address (3 cities x 5 email addresses per city) separated by a semi colon so the user could just copy the results in G1 into the To field in an email. Anyone know where I can find this or offer some sample code? Thanks in advance.