HTML Select Multiple Values in Option Menu

Hello Excel Forum,

This is my first post. I'm very new to HTML and have a little bit of experience with VBA. I am trying to navigate through a webpage so that I can eventually grab the table from the page.

There is a multi-select dropdown menu on the page similar to the drop down menu in the following link.
http://www.w3schools.com/tags/tryit....elect_multiple

I need to be able to select multiple values in the drop-down menus and then submit the search. There are multiple drop-down menus to select from. One drop menu refers to "State" and the other to "Chain". Currently, I am able to select one drop-down menu item and submit the search which can be seen in the code below.

Help is greatly appreciated! Thanks!


VBA:

Please Login or Register  to view this content.

The HTML for the "State" ID can be seen below.

Please Login or Register  to view this content.

PHP Code: 

Sub Demo1()
    Const WT = 0.00002
    Dim oIE As New InternetExplorer

    With oIE
        .Navigate "http://www.w3schools.com/tags/tryit.asp?filename=tryhtml_select_multiple"
        .Visible = True
        While .Busy Or .ReadyState < 4:  DoEvents:  Wend

        With .Document.all("iframeResult").contentWindow.Document.body.Children(0)
            .all(1).Selected = True
            .all(4).Selected = True
             Application.Wait Now + WT
            .submit
        End With

        Application.Wait Now + WT
        .Quit
    End With

    Set oIE = Nothing
End Sub 


Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

But to pilot IE is the worst way ! Intermediate way is the worksheet function Query from Web.
Better way is a request like a webbrowser uses …

Thank you for the reply. I solved it using a different method. You can see my final code below.

Code:

Please Login or Register  to view this content.