VBA Selenium Select a value from drop down menu

Asked Sep 20 '20 at 01:25

Active Sep 20 '20 at 01:25

Viewed 527 times

and thank you for reading.. New to selenium ( 4 days only) I want to select a value from the dropdown part highlighted in the image. I need to select the value "Late Speed" to the drop down selection,however I think this is a dynamic dropdown (?)

I have been playing around with the following code but not having much luck.

For Each tr2 In driver.FindElementsByClass("sectional-filters")

  For Each td2 In tr2.FindElementsByClass("sectional-filters__select")
  Debug.Print td2.Text

  If InStr(td2.Text, "Late Speed") > 0 Then
    tr2.FindElementsByTag("id").Click
    tr2.FindElementByClass("sectional-filters__select").Click
    
  End If
Next td2

asked Sep 20 '20 at 01:25

Alex of the Wild

Is there a reason you need to use selenium? Why not use queryselector? – dwirony Sep 20 '20 at 02:30
Hi , was told that Selenium was the tool to use with VBA as the web site has a lot of JScript? – Alex of the Wild Sep 20 '20 at 04:59
Try `td2.Click` instead of `tr2.FindElementsByTag("id").Click tr2.FindElementByClass("sectional-filters__select").Click` – Dilip Meghwal Sep 20 '20 at 05:40
didn't work :-( – Alex of the Wild Sep 20 '20 at 07:52

VBA Selenium Select a value from drop down menu

0 Answers0