I have a piece of HTML (listbox content) which looks like this:

"<select id="distributionListForm_mailMember" name="distributionListForm_mailMember" class="lg_field" size="5" multiple="multiple"><option value="emailaddres1@doman.com">emailaddres1@doman.com</option><option value="emailaddres1@doman.com">emailaddres1@doman.com</option><option value="emailaddres1@doman.com">emailaddres1@doman.com</option>"


I want to paste this into a cell (A1), and have a bit of VBA that tidies the string up, leaving just the email addresses.

Any pointers?