VBA: Click option on dropdown list from website

Question

Am sorry if it may be very simple, I am a newbie, but I have researched a lot without finding how to click this option (XBT/USD) inside the dropdown list: https://ibb.co/jqf7zk

I only have managed to display the list with the code below, but I don't know how to select XBT/USD because this doesn't have an ID on html source.

Option Explicit
Sub BrowseToSite()

Dim IE As New SHDocVw.InternetExplorer
Dim oSelect As HTMLInputButtonElement
IE.Visible = True

IE.Navigate "https://www.kraken.com/charts"

Do While IE.ReadyState <> READYSTATE_COMPLETE
Loop

IE.Document.getElementById("pairselect-button").Click

End Sub

HTML code according to inspect element:

< a tabindex="-1" class="currpairs" data-pair-text="XBT/USD" data-pair="XBTUSD">XBT/USD</a >

Thanks in advance for your valuable response.

On my phone, so I can't fiddle with the site very well. There is a getelementsbyclassname method you can use to return a collection of elements with the class name , you should be able to iterate through those and read the inner HTML until you find the one you want to click. — Preposterer
– Preposterer, Commented Jul 29, 2017 at 5:06

Tehscript · Accepted Answer · 2017-07-29 06:27:00Z

1

You are almost there. You have found the dropdown menu. All you need to do is clicking XBT/USD. The easiest method that comes to my mind is using getElementsByClassName but you dont have to necessarily use it. You can find them by using xpath or tagname as well.

Well, if you inspect the source you will see there are lots of class="currpairs". If you hover on them, you will see that they belong to each item in dropdown list. XBT/USD is the second item in the list. So the missing part in your code is:

IE.Document.getElementsByClassName("currpairs")(1).Click

Notice we used (1) after getting the class currpairs. This is because counting starts from 0 in list. So (0) represents the first item XBT/EUR, and (1) represents the second item XBT/USD in the list.

Hope this helps.

answered Jul 29, 2017 at 6:27

Tehscript

2,5562 gold badges15 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA: Click option on dropdown list from website

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related