Use vba selenium to choose option from drop menu

Question

PLS help me with vba selenium code. There is drop menu (name Select Bookmark) inside there is list with three option, i need to choose third option.

Tried to use some code from other solution but without success.

<ul id="aaa" class="bbb"> == $0
    ::before
    <li class="ccc">
        ::before
        <select>
            <option value>Select Bookmark</option>
            <option value="Server\BHG-145">bookmark_one</option>
            <option value="Server\BHG-155">bookmark_two</option>
            <option value="Server\BHG-165">bookmark_three</option>
        </select>
        ::after
    </li>
</ul>

Could you add the selenium you are currently using?

MaartenDev
– MaartenDev

2019-09-02 17:39:54 +00:00
Commented Sep 2, 2019 at 17:39 — MaartenDev
– MaartenDev, Commented Sep 2, 2019 at 17:39
you should really include your current code.

QHarr
– QHarr

2019-09-02 18:40:48 +00:00
Commented Sep 2, 2019 at 18:40 — QHarr
– QHarr, Commented Sep 2, 2019 at 18:40

QHarr · Accepted Answer · 2019-09-02 18:35:45Z

1

You can use an attribute = value selector

driver.FindElementByCss("[value='Server\BHG-165']").selected = True
driver.FindElementByCss("[value='Server\BHG-165']").click

or select by index

driver.FindElementByCss(".ccc select").AsSelect.SelectByIndex 3

or by text

driver.FindElementByCss(".ccc select").AsSelect.SelectByText "bookmark_three"

edited Sep 2, 2019 at 18:35

answered Sep 2, 2019 at 18:29

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Use vba selenium to choose option from drop menu

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related