VBA Web Scrapping: select item form List Box (DropDown List) by Name

[Guz Man]

Hi,


I'm trying to write a VBA script for Web Scrapping. I have to select an item form a ListBox (********** tag in HTML) by its name.


Does anybody know how to do this?


I'm using this libraries:
1. Microsoft Internet Controls
2. HTML Object Library


Here you have some of the HTML code:

                 Select a fund                                                                                                               Absolute Return Fund                                                                              Asia Pacific Ex-Japan Fund                                                                         Blended Research European Equity Fund

I would like to select the item by Name, like: Absolute Return Fund, Asia Pacific Ex-Japan Fund, Blended Research European Equity Fund.


I have Option Explicit feature on, so I would appreciate if you specify the variable type as well.


I'm not an expert programmer, so anything will help.