drop down from IE object

[Nine Zero]

Hello All,

I have a site i am going to and it contains 2 drop downs.

The selection of the first drop down triggers the options available in the second drop down to change.

for example:

drop down 1 could be
Blue
Red
Green

if blue is selected then drop down 2 will be
A
B
C

if green
D
E
F

and so on...

in my macro i have the following which works good

IE.Document.getElementsByTagName("select")("apisection").Value = "Orders"

the issue is that the second dropdown does not update the options available.

Any help?

 

[John_w]

Are there any events on the dropdown element? Use your browser's developer tools to find out.

I'm just guessing, but if there is a 'change' or 'onchange' event the code might be something like this:

    Dim changeEvent As Object
    Set changeEvent = IE.document.createEvent("MouseEvent")
    changeEvent.initEvent "change", True, False
    
    Dim dropDown As Object
    Set dropDown = IE.Document.getElementsByTagName("select")("apisection")
    
    dropDown.Value = "Orders"
    dropDown.dispatchEvent changeEvent